SQL Server Diagnostic Queries - Part 2
In this video, we are going to cover Query 4, which is Configuration Values. This query lets you see instance-level configuration values for the current instance.
This query reads from the sys.configurations catalog view, and it shows instance-level settings that you can change with the sp_configure system stored procedure.
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 2, available here: https://bit.ly/3k6NHzr
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:18 Configuration Values
0:56 Running the query
1:51 Backup Checksum Default
2:07 Backup Compression Default
2:54 Cost Threshold for Parallelism
3:27 Max Server Memory (MB)
4:02 Optimize for Ad Hoc Workloads
4:56 Remote Admin Connections
🔴 Please subscribe for more content like this!
SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER: / glennalanberry
👥 - FACEBOOK: / glenn.berry.92
LinkedIn: / glberry
Host, Video: Glenn Berry
Смотрите видео SQL Server Diagnostic Queries - Part 2 онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Glenn Berry 17 Август 2020. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 1,977 раз и оно понравилось 98 посетителям.
