If you do not have a third party monitoring tool in place, the only way is to constantly monitor SQL Server. To do this without being overly intrusive, we need to rely on the SQL Server DMVs.   Read more...

Read more...

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.  Read more...

This script finds the last run status for Full / TL backups.  Read more...

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)  Read more...

Monitoring your SQL Server instances and tracking metrics is an important part of a stable environment. New author Sadequl Hussain brings us a description of his technique for doing this across multiple servers.  Read more...

Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.  Read more...

The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.   Read more...

In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.  Read more...

An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.  Read more...

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...

Monitoring your servers centrally requires a good reporting system. Drew Salem continues with his SCOME journey to tame servers with the building of a job report in this article.  Read more...

Continuing with his series on how to centrally monitor your SQL Servers, Drew Salem looks at how to set up remote servers.  Read more...

New author Drew Salem brings us a series on how to centrally monitor your SQL Servers. He includes ASP.NET code and a framework that will check your servers and display a report for you. This article presents an overview of the dealing with the SCOME issue.  Read more...

This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.  Read more...

This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.  Read more...

Simple T-SQL to find failed SQL Agent jobs  Read more...

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.  Read more...

Learn how you can monitor the SQL Server instances for failover of a cluster or a restart.  Read more...

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.  Read more...

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.  Read more...