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
This Week in Tech (Audio) by TWiT

This Week in Tech (Audio)

3,009 Listeners

Hanselminutes with Scott Hanselman by Scott Hanselman

Hanselminutes with Scott Hanselman

377 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

246 Listeners

WSJ What’s News by The Wall Street Journal

WSJ What’s News

4,326 Listeners

WSJ Your Money Briefing by The Wall Street Journal

WSJ Your Money Briefing

1,744 Listeners

The Rich Roll Podcast by Rich Roll

The Rich Roll Podcast

11,749 Listeners

BiggerPockets Real Estate Podcast by BiggerPockets

BiggerPockets Real Estate Podcast

16,811 Listeners

a16z Podcast by Andreessen Horowitz

a16z Podcast

1,014 Listeners

SQL Data Partners Podcast by Carlos L Chacon

SQL Data Partners Podcast

27 Listeners

Dear SQL DBA by Kendra Little

Dear SQL DBA

28 Listeners

Revisionist History by Pushkin Industries

Revisionist History

59,388 Listeners

The Jordan B. Peterson Podcast by Dr. Jordan B. Peterson

The Jordan B. Peterson Podcast

34,030 Listeners

Darknet Diaries by Jack Rhysider

Darknet Diaries

7,872 Listeners

The Indicator from Planet Money by NPR

The Indicator from Planet Money

9,520 Listeners

My First Million by Hubspot Media

My First Million

2,618 Listeners