[OpsMgr] Measuring MSSQL IOPS under SCOM

Posted: June 4, 2013 in SCOM, SCOM 2007, SCOM 2012

Together with my old fellow MVP Bob Cornelissen and friend of him David Scheltens we have recently created community SCOM management pack for measuring MS SQL IOPS.
The MP is finally polished and is posted MS Technet gallery.

Starting SQL 2005 SQL DBA’s have the possibility to use Dynamic Management Views and Functions to monitor the health of a server instance, diagnose problems, and tune performance. This management pack is specifically geared towards the sys.dm_io_virtual_file_stats view, which returns I/O statistics for data and log files. The view is used by DBA’s to view current counter values for each database file (data or log). It is a current point in time and these values are cumulative values since the last restart of the server. This management pack collects these values for use in viewing and reporting. There are no health state changes or alerts connected to these values.
This Management Pack is provided free of charge by the authors to the System Center community.

MSSQL_iops

Writers of this management pack:
Bob Cornelissen. Microsoft MVP System Center Cloud and Datacenter Management, Managing Consultant of BICTT in the Netherlands, Author of the book Mastering System Center 2012 Operations Manager.
David Scheltens. Senior SQL DBA and Owner of Multibyte in the Netherlands.
Pavel Dzemyantsau. Chief IT Engineer at EPAM Systems in Belarus. Contributor to the book Mastering System Center 2012 Operations Manager.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s