Breaking News
Loading...
27/08/2013

Gather IO statistics down to the SQL Server database file level

The function returns read and write information as well as stall information, which is the time users had to wait for an I/O operation to complete.  Each time this function is called it returns the overall numbers that SQL Server has collected since the last time the database engine was started, so to use this effectively you need to gather data from two different points of time and then do a comparison

http://www.mssqltips.com/sqlservertip/1416/gather-io-statistics-down-to-the-sql-server-database-file-level/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20130823

0 comments:

Post a Comment

 
Toggle Footer