In SQL Server Mangement Studio there are some built-in reports, but they do not cover everything…
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