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...

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...

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...

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...

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...

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

SQL Server Issues? Connect with Dedicated Administrator Connection (DAC), then what? Execute this stored procedure to get some understanding on what is going on in the SQL server.  Read more...

This article describes how to install the components that make up the Management Data Warehouse (MDW)  Read more...

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...

Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.  Read more...

Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.  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...