Read SQL Server performance counters with two timed samples, a proper ratio base, and a concise workload and memory dashboard.
SQL SERVER – sp_who2 Parameters
One of my clients asked me a follow-up question in the Comprehensive Database Performance Health Check. The question was about sp_Who2 parameters.
SQL SERVER – Inserting sp_who2 Into a Table
I should also have included the script for method 1 discussed in the blog post. Let us learn a method of inserting sp_who2 into a table.
SQL SERVER – Representing sp_who2 with DMVs
A client wanted to capture sp_who2 details in a table. Here is how I represent sp_who2 with DMVs, so the data is easy to store and query.
Alerting on Long-Running Queries With a SQL Agent Job
Alert on long-running queries with a five-minute SQL Agent job, a deduplicated log, and one Database Mail notice per new request.
Database Monitoring in 2020 Results From the Latest State of Monitoring Report
Redgate Software recently released the 3rd annual State of Database Monitoring report. This year the report was extended to cover all database platforms.
SQL SERVER – Remote Monitoring While Working from Home
From developing the new project suddenly most SQL Experts (DBAs and Devs) have to start remote monitoring while working from home.