Monitoring

5 Monitoring Queries for SQL Server

  • Article

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

Survey on SQL Server Monitoring

  • Article

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

  • Article

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

SQL Monitor Metric: Processes in a runnable state (scheduler query)

  • Article

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

The Ten Commandments of SQL Server Monitoring

  • Article

It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.

2013-05-13

8,102 reads

Blogs

Daily Coping 23 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Read the latest Blogs

Forums

Colum Header adding a 1 to the text when downloading?

By jbalbo

Hi, I come across this once in a while, I have a column header...

Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

By Vladimir Isaev

We have this ad hoc query that is a recurring block leader, blocking dozens...

ADD Values from a table to an another table

By LD3060

I am working with Microsoft SQL Server MANAGMENT STUDIO 18  and i Have 2...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers