SQL Server 2012 SSMS custom reports – Database IO statistics

Oopps! Upgrade your browser pretty please.Oopps! Upgrade your browser pretty please.

In SQL Server Mangement Studio there are some built-in reports, but they do not cover everything you might want to know about your server, databases, tables, indexes or statistics. In addition to the built-in reports, I will create some useful custom reports for SQL Server 2012, and my third report is the ”Database IO Statistics” report. This report will show information about :

  • How many bytes read from file
  • How many bytes written to file
  • How many percent read vs percent written
  • Total bytes read and written
  • Read bytes / size
  • Written bytes / size

With this report you can get see if you have more reads than writes and how frequently used the databases are.   
Download SQL Server 2012 Management Studio Report: SQLServiceMonitor_Database_IO_stats.zip

I will post all my custom reports at this link : www.sqlservice.se/ssms/custom_reports.aspx

Best regards

Håkan Winther
Twitter: @h_winther