August 17, 2007 at 9:28 am
Its been hard for me to calculate exact size of space used in the DB.
My DB size when I check from properties it shows 960MB, I tried SHRINK on DB it came down to 160MB then
when I calculated by (total rowlength in DB*No.of rows in DB)/1024/1024 it came to 586MB.
I am confused...can anyone put me in the right path.
August 17, 2007 at 9:48 am
I don't think that's an accurate count. If you check the properties of each database, you will see the size and space available. The difference is your data, index, and object size.
You shouldn't shrink your DB. This messes up the indexes, creates fragmentation, etc. You need free space in your database for inserts, updates, etc. Free space isn't a problem. Having your database grow when people are trying to use it is a problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply