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

Database Fundamentals #22: Using the Join Operator, CROSS JOIN

By

While the CROSS JOIN is not used much, and, depending on the size of...

Automate Your SQL Notebooks with Two New Options

By

There are two new options for automating your SQL Notebooks with your SQL Servers....

Debugging techniques (focusing on T-SQL)

By

tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems....

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Log_Reuse_wait_Desc 'AVAILABILITY_REPLICA'

By Syed_SQLDBA

I have a very small DBs (3 GB) but I noticed that the size...

Publishing article revision updated intro comment date in article forum

By Solomon Rutzky

I recently revised an article, https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-2-sample-stored-procedure-and-function , and just noticed that, in the article-specific forum...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers