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: SQL 2000, Tips, Reports