Skip to Content
0
Former Member
Nov 16, 2010 at 09:07 AM

MSSQL - "File I/O over last 2 days"u00B4: Is more than 2 days possible?

37 Views

Dear SAP-Community,

does anyone know how to look backwards more than 2 days of the hourly detail look of I/O per file. Or does anyone some scripts to see only the last hour. Iu2019m asking because with this knowledge I could create a collector.

The common view is to go to transaction u201CST04 > Performance > I/O Performance -> dbl-click on one of the datafilesu201D. But there I cannot see more than 2 days in detail.

My environment is: Windows 2008 Enterprise SP2, SQL-Server 2008 SP1, Netw 7.01

Thanks in advance for your help!

Cheers, Manuel

PS.: Note 521750 - FAQ: SQL Server 2000 I/O performance hasnu2019t helped me. 