Version 4.1743 adds the Query Tuning Workbench, Backup SLA policies with a compliance report and alert, a Default Trace Events report, safer Quick Scan fixes, easier navigation and 920 fixes.
Twenty SQL Server connections can be healthy or a leak. Split them into running and sleeping, spot the open transaction and the sa login, then act.
Wait based tuning starts with one question: is this query running or waiting? Read the Waits by Query report in the right order.
A SQL Server disabled index sits in the catalog and does nothing. Here is how to find it, plus the low fill factor and hypothetical indexes hiding beside it.
SQL Server missing indexes look like free speed until the writes pay for them. Learn to weigh benefit against write cost before you build anything.
A silent job failure writes no history and raises no alert. Here is the order to read the Missed Runs report so the gaps tell you what happened.
Your SQL Server plan cache is memory that is not holding data pages. Split it by database, compare size to query count, and find the ad hoc SQL wasting it.
Your SQL Server CPU history is a wall of spikes on a line chart. A heat map by hour and day shows the weekly pattern and the one day that broke it.
A flat read count can hide an index sliding from seeks to scans. Here is how the SQL Server seek vs scan ratio exposes it before queries slow down.
Database Health Monitor 4.1626 adds an Index Consolidation Plan with a rollback script, reports for Service Broker, data protection and Analysis Services, and an opt-in read-only web dashboard.
We are ready to help. Steve and the team at Stedman Solutions are here to help with your SQL Server needs. Get help today by contacting Stedman Solutions through the free 30 minute consultation form.
Contact Info for
Stedman Solutions, LLC.
PO Box 3175, Ferndale WA 98248,
Phone: (360)610-7833
Our Privacy Policy