SQL Server Radio

Episode 146 - New DMVs and Application Reliability


Listen Later

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!
...more
View all episodesView all episodes
Download on the App Store

SQL Server RadioBy Guy Glantser, Eitan Blumin

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

20 ratings


More shows like SQL Server Radio

View all
Stuff You Should Know by iHeartPodcasts

Stuff You Should Know

78,688 Listeners

The Daily by The New York Times

The Daily

113,121 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

63 Listeners