Windows Server/SQL Server Performance Monitor Template

One of the nice things about Performance Monitor in Windows 2000/2003 is that it can be plugged into an HTML page as an ActiveX control. Even nicer than that is the fact that you can easily edit the parameters for the console by editing the HTML page.

Where I work, we have a handful of SQL servers. To monitor them, I created a performance monitor view with a handful of core counters on one server and saved it as an HTML file. (This is done using the Performance Monitor’s System Monitor. Simply set up your counters then right-click the monitor window and choose Save As.) Making subsequent views for other servers was as simple as making a copy of the HTML file, opening it in Notepad, and changing all server name instances.

Below is the contents of a simple performance monitor HTML page that can be used to monitor a server running Microsoft SQL Server 7.0 or higher. To use it, copy the contents into a text file, rename all instances of SERVERNAME to the name of your server, save it as a .htm file, and open it in Internet Explorer. Viola! Quick and easy view to your server’s core performance counters.

< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html>
<head>
<meta NAME="GENERATOR" Content="Microsoft System Monitor">
</meta></head><body>
<object ID="DISystemMonitor1" WIDTH="100%" HEIGHT="100%"
CLASSID="CLSID:C4D2D8E0-D1DD-11CE-940F-008029004347">
 <param NAME="_Version" VALUE="393219">
 </param><param NAME="_ExtentX" VALUE="28549">
 </param><param NAME="_ExtentY" VALUE="23839">
 </param><param NAME="DisplayType" VALUE="1">
 </param><param NAME="ReportValueType" VALUE="0">
 </param><param NAME="MaximumScale" VALUE="100">
 </param><param NAME="MinimumScale" VALUE="0">
 </param><param NAME="ShowLegend" VALUE="-1">
 </param><param NAME="ShowToolbar" VALUE="-1">
 </param><param NAME="ShowScaleLabels" VALUE="-1">
 </param><param NAME="ShowHorizontalGrid" VALUE="0">
 </param><param NAME="ShowVerticalGrid" VALUE="0">
 </param><param NAME="ShowValueBar" VALUE="-1">
 </param><param NAME="ManualUpdate" VALUE="0">
 </param><param NAME="Highlight" VALUE="0">
 </param><param NAME="ReadOnly" VALUE="0">
 </param><param NAME="MonitorDuplicateInstances" VALUE="-1">
 </param><param NAME="UpdateInterval" VALUE="5">
 </param><param NAME="DisplayFilter" VALUE="1">
 </param><param NAME="BackColorCtl" VALUE="-2147483633">
 </param><param NAME="ForeColor" VALUE="-1">
 </param><param NAME="BackColor" VALUE="-2147483633">
 </param><param NAME="GridColor" VALUE="8421504">
 </param><param NAME="TimeBarColor" VALUE="255">
 </param><param NAME="Appearance" VALUE="-1">
 </param><param NAME="BorderStyle" VALUE="0">
 </param><param NAME="NextCounterColor" VALUE="7">
 </param><param NAME="NextCounterWidth" VALUE="0">
 </param><param NAME="NextCounterLineStyle" VALUE="0">
 </param><param NAME="GraphTitle" VALUE="">
 </param><param NAME="YAxisLabel" VALUE="">
 </param><param NAME="DataSourceType" VALUE="1">
 </param><param NAME="SqlDsnName" VALUE="">
 </param><param NAME="SqlLogSetName" VALUE="">
 </param><param NAME="LogFileCount" VALUE="0">
 </param><param NAME="AmbientFont" VALUE="-1">
 </param><param NAME="LegendColumnWidths" VALUE="0.042654028436019 0.042654028436019 0.218957345971564 5.78199052132701E-02 4.92890995260664E-02 0.17914691943128 7.20379146919431E-02">
 </param><param NAME="LegendSortDirection" VALUE="0">
 </param><param NAME="LegendSortColumn" VALUE="2097272">
 </param><param NAME="CounterCount" VALUE="6">
 </param><param NAME="MaximumSamples" VALUE="100">
 </param><param NAME="SampleCount" VALUE="100">
 </param><param NAME="SampleIndex" VALUE="5">
 </param><param NAME="StepNumber" VALUE="8">
 </param><param NAME="Counter00001.Path" VALUE="\\SERVERNAME\Memory\Pages/sec">
 </param><param NAME="Counter00001.Color" VALUE="4210752">
 </param><param NAME="Counter00001.Width" VALUE="1">
 </param><param NAME="Counter00001.LineStyle" VALUE="0">
 </param><param NAME="Counter00001.ScaleFactor" VALUE="0">
 </param><param NAME="Counter00001.StatisticStatus" VALUE="0">
 </param><param NAME="Counter00002.Path" VALUE="\\SERVERNAME\Processor(_Total)\% Processor Time">
 </param><param NAME="Counter00002.Color" VALUE="128">
 </param><param NAME="Counter00002.Width" VALUE="1">
 </param><param NAME="Counter00002.LineStyle" VALUE="0">
 </param><param NAME="Counter00002.ScaleFactor" VALUE="0">
 </param><param NAME="Counter00002.StatisticStatus" VALUE="0">
 </param><param NAME="Counter00003.Path" VALUE="\\SERVERNAME\SQLServer:Buffer Manager\Buffer cache hit ratio">
 </param><param NAME="Counter00003.Color" VALUE="65535">
 </param><param NAME="Counter00003.Width" VALUE="1">
 </param><param NAME="Counter00003.LineStyle" VALUE="0">
 </param><param NAME="Counter00003.ScaleFactor" VALUE="0">
 </param><param NAME="Counter00003.StatisticStatus" VALUE="0">
 </param><param NAME="Counter00004.Path" VALUE="\\SERVERNAME\SQLServer:General Statistics\User Connections">
 </param><param NAME="Counter00004.Color" VALUE="16711680">
 </param><param NAME="Counter00004.Width" VALUE="1">
 </param><param NAME="Counter00004.LineStyle" VALUE="0">
 </param><param NAME="Counter00004.ScaleFactor" VALUE="-1">
 </param><param NAME="Counter00004.StatisticStatus" VALUE="0">
 </param><param NAME="Counter00005.Path" VALUE="\\SERVERNAME\SQLServer:Locks(_Total)\Average Wait Time (ms)">
 </param><param NAME="Counter00005.Color" VALUE="16711935">
 </param><param NAME="Counter00005.Width" VALUE="1">
 </param><param NAME="Counter00005.LineStyle" VALUE="0">
 </param><param NAME="Counter00005.ScaleFactor" VALUE="0">
 </param><param NAME="Counter00005.StatisticStatus" VALUE="0">
 </param><param NAME="Counter00006.Path" VALUE="\\SERVERNAME\System\Processor Queue Length">
 </param><param NAME="Counter00006.Color" VALUE="16776960">
 </param><param NAME="Counter00006.Width" VALUE="1">
 </param><param NAME="Counter00006.LineStyle" VALUE="0">
 </param><param NAME="Counter00006.ScaleFactor" VALUE="1">
 </param><param NAME="Counter00006.StatisticStatus" VALUE="0">
 </param><param NAME="Selected" VALUE="\\SERVERNAME\Memory\Pages/sec">
</param></object>
</body>
</html>

0 thoughts on “Windows Server/SQL Server Performance Monitor Template

  • MDF and LDF files are raw SQL database files. You need to “attach” them to a new server (must be a compatible version of SQL, of course). In the SQL management console, right-click the Databases folder and choose “Attach”.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.