September 22, 2006 at 11:47 am
We currently have a SQL 2000 server with a primary db with approx 1-2 million records with a file size of approx. 16GB.
We want to purchase a new server in order to add an additional table set of 2 million records, basically dbling the db in size.
Our current compaq server is a quad 700 with 4gb RAM and roughly 100gb of storage.
We tried adding the 2 million to the server in its current setup and the server basically slowed to a crawl.
Any recommendations for a new SQL 2005 server setup?
At peak times we only have about 100-200 connections at any one time with about 1300 batches ....
I am new to setting up new SQL servers, so be patioent with me....
September 22, 2006 at 7:49 pm
try
HP sql server free sizer:
it will help you:
http://h71019.www7.hp.com/ActiveAnswers/cache/70729-0-0-225-121.html?jumpid=reg_R1002_USEN
September 25, 2006 at 8:53 am
your hardware is probably fine, however for large updates/inserts it will always work better if you batch them.
If you can set the database to bulk logged or simple recovery this will also help.
Growing your mdf and ldf prior to the op to avoid auto grow will also give better performance.
reading from one disk to another will at least double performance. e.g. ldf on one drive, mdf on another drive, data to import on a seperate drive.
on a more advanced move increasing the recovery interval may drastically improve performance ( but NEVER do this on a cluster )
More spindles would be your best bet.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply