Dr. DMV Troubleshooting Kit - Glenn Berry - Redmond SQL User Group - January 2023

Dr. DMV's Troubleshooting Toolkit - Glenn Berry - RSUG Meeting January 2023

Description:
Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, and most CPU-intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.

This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases to avoid performance and scalability issues.

Speaker: Glenn Alan Berry @GlennBerrySQL
Glenn works as a Services Database Engineer in Elizabeth, CO. He is a Microsoft Data Platform MVP. He is also an Adjunct Faculty member at University College - University of Denver, where he has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is the author of the book SQL Server Hardware. Glenn blogs regularly at https://glennsqlperformance.com/. He is active on Twitter as @GlennAlanBerry.

Special thank you to our speaker, Glenn Berry, for sharing great content with our members.

Please visit our website @ https://redmondsql.org​ for info on upcoming meetup info.

Follow us on Twitter: @redmondsql

Don't forget to like the video and subscribes to our RSUG channel!

Тэги:

#sql #sql_server #pass #free_training #sql_server_user_group #sql_saturday #sql_pass #redmond_sql_user_group #redmond_user_group #microsoft #microsoft_sql_server #ssms #ssas #ssis #ssrs #power_bi #reporting_services #performance_tuning #sql_performance #tsql #database #sql_database #pmem #memory #azure #microsoft_cloud #big_data_clusters #sql_on_linux #kubernetes

Скачать видео