more cool usage information for sql2005

Mar 30, 07

yet another incredible article from chad boyd’s blog

this article is about “determining what objects/structures/files/etc. are consuming the largest amount of space at a given time (or over time) within the Sql Server buffer pool” in sql 2005.

i’m going to post something similar to the little one here. I had a little trouble with it running out of space in int for bytes, so I just switched to KB since that’s plenty precise for me. I also switched the formatting to something more consistent with what I typically use. code below, enjoy!