SQL Server Diagnostic Queries - Part 3

In this video, we are going to cover Query 5, which is Global Trace Flags. This query lets you see all of the global trace flags that are enabled for the current instance.

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 3, available here: https://bit.ly/2ZKGwW3

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:31 Global Trace Flags
0:45 Running the query
1:22 Trace flag 3226
1:53 Trace flag 7745
2:47 Enabling trace flags
3:37 Enabling a startup trace flag in SQL Server


🔴 Please subscribe for more content like this!


SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER:   / glennalanberry  
👥 - FACEBOOK:   / glenn.berry.92  
LinkedIn:   / glberry  

Host, Video: Glenn Berry