Everything in Database Health Monitor 4.1792: an export that asks what the file contains, a recovery page and tree badges for servers that will not connect, a Theme menu with Follow Windows, accessible 10x controls, a new Quick Scan check for SQL logins with the password policy off, and 527 fixes.
The advice to point a monitor at a real server first is wrong. Here is how sample data, the connect card and the tour work, and what each one does not tell you.
Improve scalar function performance by reading one screen in the right order: the verdict strip, the blocker matrix, then the grid beneath them.
A SQL Server untrusted constraint breaks nothing and costs you plan quality everywhere. Here is how to find them, rank them and re-check them safely.
A pending RECONFIGURE means a setting you changed is not the one SQL Server is running. Here is how to spot it, and what else the settings list gives away.
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.
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