Shrinking SQl 7 database
-
Hi
I have been trying to shrink a SQL 7 database for a week now.
The database size is 63 GB and the data size is 29 GB .
I rebuild a 7.5 Gb index every weekend .....the fragmentation of the database is in good condition ..all tables and indexes fragmentation stats doesn't exceed 5 % logical fragmentation and the scan density is 90 % or higher .
What can I do to get the free space back to the system ?
-
- how many rows get into a single datapage ?
- you could rebuild the clustering indexes.
- If you have tables that consume a huge amount of space and do not have a clustering index ? Put a clustering index on them ! (if you don't know which columns to pick, choose a increasing number column or a datetime column. If you can, use a unique column. You might even drop/create an existing index)
I have seen a lot of space wasted with heaps in sql7. Now our default is to put a clustering index on all tables for OLTP. With OLAP other strategies are in use.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply