Wednesday, March 7, 2012
How to Find Index Size / Usage (mb)
I'm trying to establish the mb usage of a series of nonclustered indexes, I'm used to using the manage indexes GUI in 6.5, and showcontig doesn't quite give me what I want, any suggestions?Have you tried sp_spaceused <table_name> yet?|||That's a great help thanks, is it possible to drill down into the 3 indexes to see how the usage is split?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment