Episode 146 - New DMVs and Application Reliability

Guy and Eitan play a game of word associations to spout a bunch of stuff about SQL Server features - mostly reviewing new system objects that replaced old DBCC commands, useful scripts in our toolbox, and talking about Application Reliability Errors.

Relevant links:

• Buffer Pool Extension
• SQL Server editions comparison dashboard by domains, features, and scale capacities – by Romain Ferraton
• SQL Server Standard vs Enteprise Edition features history – by Romain Ferraton
• SQL Server Scale Limits by Version and Edition - by Eitan Blumin
• sys.dm_os_buffer_descriptors
• Madeira Toolbox: Buffer Pool Distribution by Tables.sql
• Get the last known actual execution plan using sys.dm_exec_query_plan_stats
• sys.dm_db_page_info
• sys.dm_db_log_info
• sys.dm_db_stats_properties
• sys.dm_db_stats_histogram
• Madeira Toolbox: Shrink All Shrinkable Transaction Logs.sql
• Madeira Toolbox: Shrink_Transaction_Log_File.sql
• Madeira Toolbox: Application_Reliability_Monitor_SQLServer.sql
• Madeira Toolbox: Application_Reliability_Monitor_AzureSQLDB.sql
• PASS Data Community Summit 2022 - Register now!