• If this is a controlled environment you could use the following script (change database name):

    SELECT file_id,

    io_stall_write_ms,

    io_stall,

    num_of_writes

    FROM sys.dm_io_virtual_file_stats(DB_ID('DATABASENAME'), 2);

    http://technet.microsoft.com/en-us/library/ms190326.aspx

    Run it before your transaction and then after it to collect the deltas.



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]