Monitoring

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

dbWarden - A Free SQL Server Monitoring Package

  • Article

dbWarden is a comprehensive monitoring and alerting solution for SQL Server 2005 or newer. It features an emailed Health Report and includes email and text notifications with customizable metrics for alerts such as Blocking, Long Running Queries and SQL Jobs, CPU %, Log file and TempDB growth.

4.67 (46)

2013-04-12

20,774 reads

Blogs

Join SQLSat Memphis Virtually This Saturday

By

Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...

Failing SQL Agent Jobs – Part 4

By

Here we are, another Tuesday!! It is time for our Fourth and final installment...

I Want PASS to Survive

By

I want PASS to survive. I can say that unequivocally, because this organization has...

Read the latest Blogs

Forums

trigger on a Large 5 billion row table

By Siten0308

Hello, So we have noticed our trigger that does insert from one table to...

issue with adding another column in a table

By sameer

Hi, i have a table named as Book_master_tbl having only 10 records and as...

When one of your DBA colleagues leaves the company, what is your checklist?

By Cláudio Silva

Comments posted to this topic are about the item When one of your DBA...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers