SQL Server Diagnostic Information Queries Detailed, Day 8
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
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
For Day 6 of this series, we start out with Query #11, which is SQL Server NUMA Info. This query retrieves information from the sys.dm_os_nodes
For Day 5 of the series, we have Query #9, which is SQL Server Agent Alerts. This query looks at the sysalerts table on the
Continuing the series, Query #7 is SQL Server Services Info. It retrieves this information from the sys.dm_server_services DMV. Query 7 is shown in Figure 1.
For Day 3 of this series, we are up to Query #5, which is Global Trace Flags. This query simply runs a DBCC command to
Query #3 is Server Properties. This query simply makes multiple calls to the T-SQL SERVERPROPERTY metadata function to retrieve quite a bit of useful information
Since I have not learned my lesson from doing a daily blog post for a month from the previous several times that I have done
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.