In this video, we are going to cover Query 11, which is Host Info, Query 12 - SQL Server NUMA Info, and Query 13 - System Memory,
These queries let you see what is going on with your operating system, your NUMA topology, and your System memory usage.
This series of videos will go through the complete set of my SQL Server 2019 Diagnostic Information Queries. These queries are available for free at glennsqlperformance.com/resources.
I have a blog post that coincides with this video. It is SQL Server Diagnostic Queries – Part 6, available here: [ Ссылка ]
Note: There are separate versions of these queries for every major version of SQL Server starting with SQL Server 2005. The general concepts in these videos are applicable to all versions of SQL Server, Azure SQL Database, and SQL Managed Instance.
⏱️TIMESTAMPS⏱️
0:00 Intro
0:54 Query 11: Host Info
1:56 Query 12: SQL Server NUMA Info
4:00 Query 13: System Memory
🔴 Please subscribe for more content like this!
SOCIAL
===============================
📝 - BLOG: [ Ссылка ]
🐦 - TWITTER: [ Ссылка ]
👥 - FACEBOOK: [ Ссылка ]
LinkedIn: [ Ссылка ]
Host, Video: Glenn Berry
