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
27/08/2013
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment