Some Readings, Short Infos and SQL Server Scripts

Make your life easier

SELECTCONVERT(DECIMAL(12,3),SUM(user_object_reserved_page_count) / 128.)AS [User Objects (MB)],CONVERT(DECIMAL(12,3),SUM(internal_object_reserved_page_count) / 128.) AS [Internal Objects (MB)],CONVERT(DECIMAL(12,3),SUM(version_store_reserved_page_count) […]
Steps are: Suspend your database to close data movementsChange Readable secondary Nodes […]
;WITH BufPoolStatsAS(SELECTdatabase_id,COUNT_BIG() AS page_count ,CONVERT(DECIMAL(16,3),COUNT_BIG() * 8 / 1024.) AS size_mb,AVG(read_microsec) AS […]
SELECT total_physical_memory_kb / 1024 AS [Physical Memory (MB)],available_physical_memory_kb / 1024 AS [Available […]
DECLARE @now BIGINT;SELECT @now = cpu_ticks / (cpu_ticks / ms_ticks)FROM sys.dm_os_sys_info WITH […]
Your database's LDF file, that is, the LOG file, has grown, you […]
Running DBCC CHECKDB and get out of TEMPDB errors although having enough […]
You realized that your database has grown and you want to check […]
Let's assume that you have created separate datafile for non-clustered indexes but […]