Monitor SQL Server CPU Loads - Page 2

Step 8

Execute C:\RRD\CreateDB.bat. [Refer Fig 1.2]

This creates an .rrd file for every processor for the servers listed in server.txt.

Step 9

Create a Schedule to run the batch file C:\RRD\monitor.bat every 5 minutes as shown below. Refer Fig 1.3 and 1.4

This schedule runs every minute and updates the .rrd database file for all of the servers listed in server.txt

Step 10

Collect information for the whole day and execute the command below to generate a graph. Refer Fig 1.5

Step 11

Execute the command below to see the graph Refer 1.6. It opens the PNG file with the associated default application. Refer Fig 1.7

Step 12

If you want to create one graph with all of the processor loads on it, then execute the show_graph2.vbs as shown below. Refer fig 1.8

Note: show_graph2.vbs can produce a graph for 16 processors. If the number of processor exceeds 16, it will fail to create the graph.

Step 13

Execute the command below to see the graph. Refer 1.9. It opens the PNG file with the associated default application. Refer Fig 2.0

Conclusion

As mentioned before, this article illustrates how to monitor the CPU load on multiple SQL Server machines. It also illustrates on how to collect data in Round Robin database to produce a graph. This helps in determining the heavily used and under utilized servers. The illustrations of this article can be applied on any windows machine with WMI.

RRDTool, developed by Tobias Oetiker, is available under GNU General Public License.

» See All Articles by Columnist MAK