2018-06-08 (first published: 2018-01-03)
2,518 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,140 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
Microsoft Purview FAQ
By James Serra
I get many of the same questions about Microsoft Purview, so I wanted to...
Undercover Catalogue 0.4.5 Released – Database Module Bug Fix
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
Saving Emergency Space on my Laptop
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
backups failure
Hello All, We have a domain account running sqlserver service.this account has r/w access...
Question of the Day
Setting Emergency State
Which server role(s) can set a database to the Emergency State?
See possible answers