SQL Server Always On – Monitor The Redo_Queue_Size

Cause sometimes you need to check why replication is slow or halted. For example, like during an IO storm - no hurricane pun intended. Say you have transnational replication over an Always On (SQL Server Availability Groups) environment that's a publisher. To see in the Dashboard just add the column, this is what it looks…

2 New Things in SSMS 17.2 – I Think You’ll Like.

QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats. Performance Dashboard server report now available as a default report: Can connect to SQL Server 2008 and newer versions. Missing indexes sub-report uses scoring to assist in identifying most useful indexes. Historical wait stats sub-report now aggregates waits by category. Idle and…

SQL Server 2016+ Query Store Blitz – This is AWESOME!

Check out: https://www.brentozar.com/archive/2017/06/introducing-sp_blitzquerystore/ Test it like this:   Here's the sp_BlitzQueryStore.sql - Thank you Erik Darling! If you have SQL Server 2017+ it gives you the top 3 wait stats per plan too. Download it here, via the link above or copy it and run it on Master db. Enjoy! Hiram