ORM SQL Server Performance: Which Framework Is It?
ORM SQL Server performance problems hide behind one program name. Learn how to spot the framework, its Unicode parameters and its transactions, and fix them.
Database Health Monitor
Version 4.1869: Get Answers From Your SQL Server History Before the Auditor Asks
What Database Health Monitor 4.1869 means for the people accountable for SQL Server: monthly summaries, capacity dates, accountability reports and PDF output.
Logical Reads Per Row: Which Query Reads Too Much?
Total reads rank the loud query, not the wasteful one. See how logical reads per row separates honest scans from lookups with a missing index.
WRITELOG Wait: Slow Storage or One-Row Commits?
A WRITELOG wait has two opposite fixes: faster storage or batched commits. Here is how to tell which one your SQL Server needs before you… Read More »WRITELOG Wait: Slow Storage or One-Row Commits?
Write Amplification SQL Server Table: What One Row Costs
Find the write amplification SQL Server table behind slow inserts and a growing log. See what one row costs in indexes, triggers and history, then… Read More »Write Amplification SQL Server Table: What One Row Costs
SQL Server Linked Servers: The Trust Nobody Reviews
Most SQL Server linked servers are created once and never reviewed. Here is how to find the dead ones, the duplicates and the wide open… Read More »SQL Server Linked Servers: The Trust Nobody Reviews
Version 4.1818: Put Your SQL Servers on the Wall and Catch Problems Before Users Do
What Database Health Monitor 4.1818 means for a team that runs SQL Server without a full time DBA: shared dashboards, a wall display, patch currency… Read More »Version 4.1818: Put Your SQL Servers on the Wall and Catch Problems Before Users Do
TDE Certificate Backup: The Restore That Cannot Open
A TDE certificate backup that was never exported turns a restore on another server into an unreadable file. Here is how to check master in… Read More »TDE Certificate Backup: The Restore That Cannot Open
SQL Server Patch Level: Which Servers Are Behind?
Nobody can say which servers are behind on cumulative updates without logging into each one. Here is how to read your SQL Server patch level… Read More »SQL Server Patch Level: Which Servers Are Behind?
Version 4.1796: Faster Answers and Fewer Slow Queries for Teams That Run SQL Server
What Database Health Monitor 4.1796 means for small teams: less guessing, better conversations with developers and vendors, and earlier warning on blocking.