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
Three different inspection tools sit beside the same workpiece and retained samples.

SQL SERVER – How Do I Evaluate Monitoring Tools?

May 8, 2019
Pinal Dave
SQL Performance
SQL Monitoring, SQL Server, SQL Utility

I evaluate monitoring tools by collection cost, historical context and usefulness in choosing a correction. Customer discussions shaped those three criteria.

Read More
A quiet loom still holds unfinished fabric connected to its yarn supply.

SQL SERVER – Reviewing Sleeping Sessions Before Terminating Any Session

May 6, 2019
Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL DMV, SQL Monitoring, SQL Scripts, SQL Server

An inactive or sleeping session may still be a useful pooled connection. A customer case prompted my earlier session-cleanup script.

Read More
A row of full fish crates on a quay at dawn, one crate at the end holding only a few fish

Spotting Unusually Small Backups Against Each Database’s Average

April 17, 2019
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Monitoring, SQL Scripts

Flag unusually small backups against database-specific history, use aggregate filtering, and investigate alerts without assuming data loss.

Read More
Table of the five sp_who2 statuses: Running has a thread and CPU, Runnable has a thread and waits for a free CPU cycle, Pending has no thread and waits for one, Suspended waits for a resource, mostly I/O, and Sleeping does nothing

Runnable vs Suspended: What Each sp_who2 Status Means

March 15, 2019
Pinal Dave
SQL Tips and Tricks
Disk, SQL CPU, SQL Monitoring, SQL Server

Runnable vs suspended is the question I hear most about the sp_who2 status column. A Runnable session waits for CPU, and a Suspended one waits for a resource such as I/O. Here are all five statuses in plain words.

Read More
An ice resurfacing machine making its last pass across an empty rink while skaters wait at the gate

Tracking Backup Throughput and Duration From msdb History

February 14, 2019
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Monitoring, SQL System Table

Track backup throughput and duration from msdb history, compare recent trends, and keep striped devices from duplicating backup totals.

Read More
EXEC sp_who2.

SQL SERVER – 5061: FIX Error: ALTER DATABASE failed because a lock could not be placed on database ‘Database Name’. Try again later.

November 27, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Monitoring, SQL Scripts, SQL Server

Trying to take a test database offline, we hit Msg 5061: ALTER DATABASE failed because a lock could not be placed on database. Here is how to fix it.

Read More
A wide stone culvert with a trickle of water and a high line of dried debris from spring floods

Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation

September 6, 2018
Pinal Dave
SQL Performance
DBA, SQL CPU, SQL DMV, SQL Memory, SQL Monitoring

Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.

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

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