2018-06-08 (first published: 2018-01-03)
2,520 reads
Monitoring
5 Monitoring Queries for SQL Server
Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in your head. Dennes describes how he uses T-SQL queries for solving problems, whether it involves fixing the problems of missing indexes, preventing unrestrained autogrowth, avoiding index fragmentation, checking whether jobs have failed or avoiding memory stress conditions.
2016-07-08
10,110 reads
Free Guide: Eight Steps to Effective SQL Server Monitoring
This free guide includes worked examples, practical advice, and covers the hows and why of SQL Server monitoring. Download the guide and get a 26 monitoring tips as well.
2015-05-20
10,591 reads
Survey on SQL Server Monitoring
If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.
2015-04-28
7,309 reads
Centralize Your Database Monitoring Process
SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to configure it to run on maybe hundreds of instances using Central Management Server. Dennes describes how to tame the system so that it scales.
2015-02-04
8,923 reads
Monitor Database Growth and Usage
Create a repository of all your database devices and stay informed about changes in their size and usage.
2014-12-04
11,175 reads
The 3AM Meltdown - New DBA Team Article
Where do you start fixing a SQL Server crash when there isn’t a single clue? The DBA Team had better find out quick, or they’re not going to get any sleep tonight. Find out how it all goes.
2014-10-16
9,976 reads
The Road To Hell - new article from the DBA Team
Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.
2014-08-07
11,971 reads
SQL Monitor Metric: Processes in a runnable state (scheduler query)
Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.
2013-12-03
3,671 reads
Eight Steps to Effective SQL Server Monitoring
If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.
2013-08-26
5,456 reads
Blogs
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
SQL Saturday Atlanta BI Recap
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Display Data
Hi I want below data to appear like below using query CREATE TABLE [dbo].[Test](...
SQL 2017 server keeps locking up
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers