SQL Server Diagnostic Information Queries Detailed, Day 18
For Day 18 of this series, we start out with Query #41, which is Memory Clerk Usage. This query retrieves information from the sys.dm_os_memory_clerks dynamic
For Day 18 of this series, we start out with Query #41, which is Memory Clerk Usage. This query retrieves information from the sys.dm_os_memory_clerks dynamic
For Day 17 of this series, we start out with Query #39, which is PLE by NUMA Node. This query retrieves information from the sys.dm_os_performance_counters
For Day 16 of this series, we start out with Query #37, which is CPU Utilization History. This query retrieves information from the somewhat undocumented
For Day 15 of this series, we start out with Query #35, which is Avg Task Counts. This query retrieves information from the sys.dm_os_schedulers dynamic
For Day 14 of this series, we start out with Query #33, which is Top Waits. This query retrieves information from the sys.dm_os_wait_stats dynamic management
For Day 13 of this series, we start out with Query #30, which is CPU Usage by Database. This query retrieves information from the sys.dm_exec_query_stats
For Day 12 of this series, we start out with Query #27, which is Database Properties. This query retrieves information from the sys.databases catalog view,
Today, we will go through four queries that are related to storage. We start out with Query #23, which is Volume Info. This query retrieves
For Day 10 of this series, we start out with Query #21, which is Memory Dump Info. This query retrieves information about any SQL Server
For Day 9 of this series, we start out with Query #19, which is BPE Configuration. This query retrieves information about your buffer pool extension
For Day 8 of this series, we start out with Query #16, which is Hardware Info. This query retrieves some hardware-related information from the sys.dm_os_sys_info
Note: The three queries I am discussing today are not particularly interesting or useful if you are not using either a traditional, failover cluster instance
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.