Today, I am going to talk about the 3 important properties which I look for in all the SQL Server Performance monitoring tools.
SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2
A third party app kept connections open and hurt a client’s performance. While they waited for a patch, we used this script to kill all inactive, sleeping sessions.
SQL SERVER – Performance Monitoring Week – Wrap Up
I absolutely love my job using Comprehensive Database Performance Health Check, which has inspired me to write Performance Monitoring Week.
SQL Server Monitoring Week – SQL Plan Warnings
The next stop in my SQL Server Monitoring Week is SQL Plan Warnings. I take a brief look at the warnings hidden in query plans and why they are worth watching.
SQL Server Monitoring Week – Spotlight Cloud
I begin a week-long series on SQL Server monitoring tools, starting with Spotlight Cloud and how it helps detect and diagnose performance issues.
SQL Server Monitoring Week – SQL Monitor
Next in my SQL Server Monitoring Week is SQL Monitor, and I take a brief look at how it can help you keep an eye on your SQL Server’s health.
SQL Server Monitoring Week – SQL Diagnostic Manager
SQL Server Monitoring Week continues. Many clients struggle to monitor SQL Server health, so today I take a brief look at SQL Diagnostic Manager (SQLDM).