UtilityDB.2.0

Rating: No reviews yet
Downloads: 186
Change Set: 34428
Released: Aug 9, 2014
Updated: Aug 10, 2014 by sfibich
Dev status: Stable Help Icon

Recommended Download

Source Code Version_02dot0.zip
source code, 21K, uploaded Aug 10, 2014 - 186 downloads

Release Notes

Release Notes: Version 2.0
This is the second release of the UtilityDB, it builds on top of and includes the Version 1.8 of code. This release focus on performance metrics in particular Disk I/O. The deployment scripts have been rewritten to utilize transactions to insure completeness of script execution. This project releases the source code as a SQL Server 2012 project file. The intended way to deliver the scripts
to the database is through the execution of the @BuildScript.sql in the SSMS SQLCMD mode.
This will place all of the objects in the current database for this release.

New Objects:
udb.iofilestats (Table) - Holds data from the sys.dmiovirtualfilestats DMV
udb.gatheriofilestats (Procedure) - Collectes data from sys.dmiovirtualfilestats DMV and inserts it into udb.iofile_stats
iofilestatsoverview (View) - View over top of udb.iofile_stats.

Modified Objects:
N/A

Removed Objects:
N/A

The script execution has been tested in Microsoft SQL Server Management Studio using SQLCMD mode.

SQLCMD mode can be set by going to Query Menu then choosing SQLCMD mode.

Reviews for this release

No reviews yet for this release.