Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior.
2019-04-25
Monitoring your SQL Server is important. This article examines one of the metrics you might want to keep an eye on.
2021-02-26 (first published: 2019-02-26)
46,155 reads
Learn how you can post notifications from SQL Server directly to a Slack channel.
2018-10-23
2,461 reads
Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.
2018-02-06
3,868 reads
2018-06-08 (first published: 2018-01-03)
2,535 reads
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
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
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
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
Create a repository of all your database devices and stay informed about changes in their size and usage.
2014-12-04
11,242 reads
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
is there a no code way to limit an ssis extract from excel to...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
hi we have to replace talend which generally was used to move files. talend's...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers