July 24, 2002 at 1:24 pm
What system tables or procs. can I use to detect candidate databases for shrinking?
(not unused space but fragmented db's)
-Kevin
July 24, 2002 at 1:30 pm
dbcc showcontig shows fragmentation on tables.
Steve Jones
July 24, 2002 at 1:49 pm
Yes, that shows valuable info. but I would have to spool that info. to a table and do some derived columns to see who is a candidate.
When you use the g.u.i. to shrink a db it display s the percent of free space. What system table or proc. is it executing to estimate that free space so quickly???
-K
July 24, 2002 at 4:01 pm
you'd have to manually spool it, but your question was fragmentation. If so, you have to look at tables.
If you want free space, then that is by database, sp_spaceused
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply