November 14, 2003 at 6:58 am
Hi all,
We have just upgraded sql6.5 with sp 5a to 7.0 on NT. The user database (only one user db) was 4Gb data on 6.5. After upgrade, that user database is 9Gb of data (data file size is 11Gb). We have about 30,000 small tables in that user db. When I ran DBCC checkdb no error reported. Is it correct? Month ago, I did similar upgrade on other NT server with 2Gb user database of 3,000 small tables in it, no big difference on size before and after upgrade.
Thanks!
Paul Joe
November 17, 2003 at 8:00 am
This was removed by the editor as SPAM
November 20, 2003 at 10:43 am
This does seem very odd. I've done many upgrades and sometimes the files size will grow by at most a few hundred megs. Can you look for dups in your tables and ensure that the tables didn't get appended twice. You may also want to look at the table sizes before and after (assuming this was not an in place upgrade) and see if there is one table in particular that is a problem (use something like http://www.sqlservercentral.com/scripts/contributions/558.asp to get a list of all tables in DB.
If all looks good defrag/rebuild your indexes to look for large fill factors.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply