SQL Server Monitoring Scripts with the DMVs

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.

SQL Server Information

Checking the Job Status on Multiple Servers

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.

Collect SQL Server/Process Information - Quickly

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

Saving Time with Proactive DBA Monitoring

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.

Monitoring group of Linked Sql Servers from a Sql Server

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

Tracking and Reporting Database Growth

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.

Monitor Any Linked Server From SQL 2000

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005

Who did what?

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