May 1, 2003 at 12:25 pm
I am running SQL Server 2000 on 2 servers with identical databases that are replicated.
One database is 800 MB and the other is 90 Mb. Both servers should be about 90 Mb. I have tried shrinking the large one many times with just a minimum shrinkage. Any suggestions, I think this is also creating a performance hit
May 1, 2003 at 12:42 pm
800 MB database is pretty small in SQL Server and it shouldn't impact the performance unless database, queries and tables indexes were not properly designed.
Try to run dbcc dbreindex your large database and sp_spaceused @updateusage = true to see any changes in its size.
Edited by - Allen_Cui on 05/01/2003 12:46:29 PM
May 8, 2003 at 12:46 am
Use clustering indexes so a dbcc dbreindex also affects your datapages. check your fillfactor settings. run sp_statistics and updateusage to get correct numbers. check BOL.
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
May 8, 2003 at 3:11 am
Also, use DBCC SHIRNKDB or DBCC SHRINKFILE to cut out any excess space not in use.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply