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>
Phuong Moctezuma says:
Howdy, I figured you will be able to help me. I have an Microsoft SQL .ldf and .mdf file that I have to restore. Any opinions on how to achieve this? Cheers
brian says:
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”.