Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

Wednesday, 15 March 2006 - Posts

Upgrade to [Measure database file i/o with fn_virtualfilestats (SQL2000 AND SQL2005)]

I'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,Greg
posted by Greg_Linwood | 2 Comments
Filed Under:

SQL Profiler - Errors & Warnings: Blocked Process Report

Now, here's a cool new SQL 2005 Profiler event I used for the first time in anger yesterday. What I love about this event is that it actually spits out significant & useful data from both the blocked process & blocking process - locked resource, input