SQL 2000,Reports - Andrew Calvett

Browse by Tags

Server level VLF report
25 July 2007 23:27
I read Tony Rogerson's blog on Virtual Log Files today and it reminded me that i really should knock up a little report to list all databases on a server and the number of VLF's per database. Since I had been busy writing some other Operational reports I was in the right frame of mind so knocked up what you see below. The Report code CREATE TABLE #VLFS ( fileid... Read More...
by ACALVETT | 2 comment(s)
Filed under: , ,