Monitoring

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

19,305 reads

An Easy Way to Monitor SQL Server Replication

  • Article

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.

2011-10-26

3,444 reads

Preventing Problems in SQL Server

  • Article

It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.

2011-09-01

3,959 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