Is This Query Slower Than Normal? Ask Its Own History
Is this query slower than normal? Learn how per-query limits from Query Store history separate a real slowdown from ordinary wobble.
Author: Steve Stedman
master Backup Out of Date? Here’s How to Check It
A master backup out of date can pass every check and still miss logins, role grants, and linked servers created since it ran. Here’s how to see the gap.
Elevate Your Database Health with a Robust Backup and Recovery Plan: Limited-Time Offer on SQL Server Course
Hello! Steve Stedman here. Today, I’d like to emphasize the critical importance of maintaining the health of your SQL Server database through an unshakeable backup and recovery plan. Why? Because in our data-driven world, the absence of a comprehensive backup strategy can spell disaster for your organization. This is precisely why I’ve designed a specialized Backup and Recovery Course for SQL Server, and I am thrilled to shaer a limited-time 25% discount on this indispensable resource. The Importance of Backup …
Database Health Monitor 4.1517
Database Health Monitor and Azure SQL Health Monitor, Version 4.1517 This release adds ninety new reports, a drill-through navigation layer that connects them, actions that carry a fix from one instance to the rest of the estate, and a large pass over silent failures. If you knew the symptom but not the page, or fixed one server and then had to repeat the fix by hand on the other twelve, this release is aimed at you. 90 New Reports Three new …
SQL Server Job Slow When Others Run? Here’s Why
A job slow when others run isn’t a broken package. See how Database Health Monitor’s Subsystem Load report finds the Agent worker limit causing it.
Why Autogrowth in Percent Slows SQL Server Down
Autogrowth in percent compounds: every growth event takes longer than the last. Here’s how to spot it and fix it before it slows down SQL Server.
SQL Server Technical Debt: Where to Start Fixing It
SQL Server technical debt turns messy T-SQL into a weighted score and a cost estimate, so you know which procedure to fix first.
Why a Wide Clustered Index Costs More Than You Think
A wide clustered index gets copied into every nonclustered index on the table – here is how to find the ones actually costing you.
Who Changed the Schema? Find Out in SQL Server
See who changed the schema in SQL Server: the exact statement, login, host and application, captured by a DDL trigger you switch on per database.
Find the SQL Server Deadlock Objects That Keep Colliding
See which SQL Server deadlock objects collide with each other, on what index, under what lock mode, and which one loses every time.