Yesterday, I had posted an issue I been troubleshooting with memory allocation. That was causing CPU to pin, you can read more about the issue
Category: Dynamic Management Views/Functions
Using sys.dm_io_virtual_file_stats DMF to get IPOS and BPS
SQL Server keeps track of all the reads and writes it submits to the operating system (OS). It records this information in sys.dm_io_virtual_file_stats DMF. We
A Microsoft SQL Server DMV/DMF Cheat-Sheet
I am asked this question by Microsoft SQL Server customers again and again: “What dynamic management views (DMV) or dynamic management functions (DMF) should I
Getting List of Top Queries by Query Hash
Starting SQL 2008, we have had Query Hash column in sys.dm_exec_query_stats. It helps group common queries together, because when SQL Server is generating execution plan
Getting List of Fragmented Indexes in a Database
Index fragmentation is naturally happens as an action of insert, deletes and updates. It is important to manage this fragmentation, if not you can have
Finding All Plans/SQL Statements that executed in Parallel
References: #21 Statement copied from The Rambling DBA: Jonathan Kehayias Blog