Which database is consuming my memory? This query on sys.dm_os_buffer_descriptors counts buffer pool pages per database and page type.
SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds
Seeing ‘I/O requests taking longer than 15 seconds’ in the ERRORLOG? Here is what this common warning means and where to look for the slow disk behind it.
SQL SERVER – Table Space Allocation Details using DMV
Beyond DBCC IND and EXTENTINFO, the DMV dm_db_database_page_allocations shows table space allocation details. My friend Balmukund pointed me to it.
SQL SERVER – How to See Active SQL Server Connections For Database
A reader asked which users are connected to a database and with how many connections. This short script lists active SQL Server connections by login.
SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup – Optimized
An optimized script from SQL expert TheSQLGuru that shows the last backup time for all databases, covering the last full, differential and log backup.
SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation
What are all the reasons a statement recompiles? I found the full list with the DMV sys.dm_xe_map_values, handy when you read a Profiler or Extended Events trace.
SQL SERVER – Identify Last User Access of Table using T-SQL Script
How do you find the last user access of a table? A question at TechEd India 2013 led to this quick DMV script. Keep in mind the data resets on restart.