this select will show the last sql statement for every open session plus many helpfull information.  Read more...

Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.   Read more...

An interesting tale of David Bird's fight with tempdb.  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.  Read more...

As a follow up to my first article “Monitoring on a Budget”, here’s how we present the fact data to management using Microsoft Excel.  Read more...

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s  Read more...

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...

Every extra byte of space you waste in your database causes a performance hit to your application. This article looks at disk space usage and how it affects performance.  Read more...

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...

SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace files in TSQL to catch events on your database machine.  Read more...

While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.   Read more...

Monitoring in the real world. Roy Carlson concludes his series on space monitoring for your SQL Servers with a real world example of how he found a problem and fixed it.   Read more...

Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data.   Read more...

Continuing with his series on monitoring space, Roy Carlson looks at checking the space in a folder to be sure your SQL Server databases never run out of storage.   Read more...

SQL Server will autogrow your databases as they run out of space. But the process doesn't manage space, nor does it check the free space on the drive. Allowing autogrow to grow unchecked and unmanaged will eventually use up all the free disk space and potentially crash your server. New author Mark Nash brings you his system for monitoring space usage and generating a report that eases this process.   Read more...

In this series of articles, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We will use VMware Workstation 5 to create the lab to introduce you to the basics of installing MOM to monitor SQL Server.   Read more...

Part I of this article illustrated how to monitor CPU usage of running processes on a local machine or from a remote machine. This article illustrates how to monitor the CPU usage of different running processes on different machines and collect the information in a database.  Read more...

SQL Server Profiler can correlate Microsoft Windows System Monitor (Performance Monitor in Windows NT 4.0) counters with SQL Server or SQL Server 2005 Analysis Services (SSAS) events. Windows System Monitor logs system activity for specified counters in performance logs. The first thing to remember is in order to have correlating information you need to obviously be in sync - in other words you must start the perfmon trace and profiler trace at the same time or else they won't match up.  Read more...

Joe has a bunch of small, easy to use scripts that can definitely be the beginning of a great set of monitoring tool. Amazing how much info you can gather with a little bit of code!   Read more...

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s  Read more...

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...