|
Posted by Neil on 12/25/07 01:15
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A114FA9BFBDYazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> It shows about half a gig of unused space. Here's the printout:
>>
>> database_size unallocated space
>> --------------------------------------
>> 3355.75 MB -2571.25 MB
>>
>> reserved data index_size unused
>> ------------------ ------------------ ------------------ -----------------
>> 6069248 KB 2477728 KB 3066760 KB 524760 KB
>
> The negative number for unallocated space is spooky. Run it again,
> but now like this:
>
> sp_spaceused NULL, true
>
> That will make sure the values in sysindexes are updated.
>
OK, here it is:
database_size unallocated space
------------------ ------------------
3355.75 MB 338.75 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
3089408 KB 2480768 KB 166896 KB 441744 KB
> By the way, are you still on SQL 7? I seem to recall that you talked
> up moving on to SQL 2005, but did that materialise?
It's still upcoming. Hopefully in the next month or two. You think that
might make a difference with this situation?
>
>> The maintenance job that is run nightly performs the following:
>>
>> Optimizations tab:
>>
>> Reorganize data and index pages
>> (change free space per page percentage to 10%)
>
> That's OK.
>
>> Remove unused space from database files
>> (shrink database when it grows beyond 50 MB)
>> (amount of free space to remain after shrink: 10% of the data space)
>
> But remove this one. Shrinking the database is not a good thing to do
> on regular terms.
OK, removed it. Is that something I should do periodically?
Thanks!
Neil
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|