Skip to content
Tagged articles

DMV

2 articles · Page 1 of 1
ITPUB
ITPUB
Oct 14, 2026 · Databases

100 Essential SQL Server DBA Commands for Production Troubleshooting

A comprehensive reference of 100 practical T-SQL commands for SQL Server 2016-2022 DBAs, organized into ten categories covering instance basics, space management, session analysis, locking, performance tuning, indexes, Always On, backup/recovery, permissions, and daily health checks.

Backup RecoveryDBADMV
0 likes · 12 min read
100 Essential SQL Server DBA Commands for Production Troubleshooting
ITPUB
ITPUB
May 30, 2018 · Databases

How to Monitor SQL Server Backup and Restore Progress Effectively

This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.

DMVRestoreSQL Server
0 likes · 7 min read
How to Monitor SQL Server Backup and Restore Progress Effectively