http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/03/15/59.aspxI'm up-grading a script I posted a few weeks back which measures i/o at database file level. Included in the new script are: (a) Physical O/S filenames(b) Physical O/S file volumes(c) A secondary, summary report of i/o, aggregated to volume level. Cheers,Gregen-AUCommunityServer 2.0 (Build: 60217.2664)http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/03/15/59.aspx#1343Tue, 02 Sep 2008 22:43:23 GMT6d5687b6-8fdc-4d13-899b-485dc578ece0:1343AnonymousContext switching can be hard to understand and measure. As it turns out, you can use the PerfMon counterhttp://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/03/15/59.aspx#1344Tue, 02 Sep 2008 22:43:38 GMT6d5687b6-8fdc-4d13-899b-485dc578ece0:1344AnonymousPingBack from <a rel="nofollow" target="_new" href="http://sqlserverpedia.com/blog/tuning-and-optimization/counting-context-switches-perfmon-counters-and-other-miscellaneous-notes/">http://sqlserverpedia.com/blog/tuning-and-optimization/counting-context-switches-perfmon-counters-and-other-miscellaneous-notes/</a>