This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A hand clipping a peg at the water level of a rain tank's sight tube, older pegs stepping down above

Logging Free Space per Volume Into a Table Each Day

July 9, 2020
Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Data Storage, SQL DMV, SQL Monitoring

Log free space per volume from SQL Server volume metadata, keep one daily sample per mount point, and compare change with LAG.

Read More
Gouache painting of a row of open beach umbrellas with one closed vermilion umbrella at the end

Visible Offline Schedulers: Find CPUs SQL Server Ignores

May 12, 2020
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Monitoring, SQL Server Configuration

Visible offline schedulers are CPUs that Windows shows and SQL Server refuses to use. This post reads the scheduler status with tested queries, compares it with the CPU count and affinity, and explains the two common causes. It also shows the statement that returns the CPUs to automatic affinity.

Read More
Gouache painting of a row of tilted pinwheels in the sand with the still middle one vermilion

Activity Monitor Keeps Freezing: Fix WMI and Permissions

April 8, 2020
Pinal Dave
SQL Tips and Tricks
SQL Activity Monitor, SQL Monitoring, SQL Server Security, WMI

When Activity Monitor keeps freezing, the cause can be a missing SQL permission or a missing WMI permission for the Windows account. This post tests the SQL side on SQL Server 2025, walks through the WMI security fix and explains what CIMV2 means. It also gives a query that reads the same activity without Activity Monitor.

Read More
Gouache painting of an overflowing vermilion basket of linens beside a single copper washtub

Query for CPU Pressure: Sample the Scheduler Queue

April 2, 2020
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Monitoring, SQL Scripts

To sample the scheduler queue, read the runnable counts of every scheduler eight times, one second apart, and compare the result with a baseline. This post shows the queue on a quiet server and again while more busy sessions than schedulers run. It reads the spread, the streak and the average that tell pressure from noise.

Read More
A rack of lake water samples at dawn, one cloudy tube marked with a red clip.

Capturing sp_WhoIsActive Snapshots to a Table Every Minute

January 24, 2020
Pinal Dave
SQL Tips and Tricks
DBA, SQL Monitoring, SQL Server, SQL Server Agent

Capture sp_WhoIsActive snapshots every minute, keep seven days, and query past blockers and long requests from a logging table.

Read More
A pot of rice cooking under a clear glass lid, grains visible through the mist, a spoon resting untouched beside it.

Lightweight Query Profiling: Live Progress Without the Old Overhead

December 27, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Monitoring, SQL Server, SQL Server 2019

Use lightweight query profiling to inspect live operator rows and in-flight plans, while avoiding misleading progress percentages.

Read More
A filling bathtub with a red float tied to a small brass bell on the rim.

Performance Condition Alerts: Warnings Before a Log File Fills

June 20, 2019
Pinal Dave
SQL Tips and Tricks
DBA, SQL Monitoring, SQL Server Agent, Transaction Log

Build performance condition alerts for log usage, tempdb free space, and blocking, with sensible delays and an operator response.

Read More
Previous 1 2 3 4 5 6 … 10 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com