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!