June 11, 2008 at 2:44 pm
I have a SQL Server 2005 database and the total reserved table size (data and index spaces) for all the user tables gathered from Dataabse Report of "Disk Usage by Top Tables" is about 40 GB, but the database property shows 92 GB. mdf is 91 GB and ldf is 1 GB. The full backup is also about 92 GB.
I executed DBCC UPDATEUSAGE('dbname'), but nothing was changed. I thought 40 GB should be the correct size. I tried to shrink the data file, but there was no free space left to be shrunk (only about 30 MB free).
Your input will be greately appreciated.
BL
June 11, 2008 at 6:30 pm
Dunno. Guessing here but does this report include index space used ?
(sudden attack of laziness is preventing me from checking this myself)
The systems fine with no users loggged in. Can we keep it that way ?br>
June 12, 2008 at 4:28 am
The reserved size includes data and index spaces. Used space is about 90% and unused is 10%. Again reserved size is 40 GB. Only 1 file group is used.
June 13, 2008 at 6:23 am
I'm having a very similar problem and it looks like my problem is fragmentation in the indexes themselves. I found a script that identifies large tables and in the output of that script it shows the unused space in the indexes.
Here is the name and author of that script.
BigTables.sql
Bill Graziano (SQLTeam.com)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply