SQL Server Power Search - Get More Relevant Results

SQL Server Monitoring Script - Part 2

In the first part of this article I described a SQL Server Monitoring script that I use daily in large environments. In the second part I give you the code and explain how to set it up.

First, the code. Create a file called SQL Snapshot.hta, open it with notepad and paste the following into it:
If you have already tried out the Audit script described in SQL Server Audit Script - Part 2 this SQL Server Monitoring script uses the same xml file.

If not, create a file called SQL Servers.xml and save it to the same folder, open it with notepad and paste the following xml into it:


This should be fairly self-explanatory. The name attributes may contain a server name or ip address. The desc attributes contain what is displayed to the user. Windows and SQL Server authentication are both supported, and I have shown examples of each. The grouping is useful in a large environment. You can have as many groups as you like.

Replace my example servers and instances with ones from your own environment and save the file. Now double-click on SQL Snapshot.hta to run the script.

When I make future changes to this SQL Server Monitoring script I will describe them in a new article, so be sure to subscribe to my RSS feed.