June 22, 2009 at 4:50 am
Hello I am new to posting in this forum
I am SQL server developer and most of my expereince is on the development side. However, there's no DBA at my company and we need some help with some of the DBA activities.
Currently we have two sql server 2000 production servers, we have about 20 databases or so. I look after about 5 or 6 of those databases.
Our IT manager wanted to implement HA on those server, she also wanted to know what spec we should get for the hardware to implement HA.
The question I have, is there any ways or tools to do stress or performance tests on the server to determine a new suitable hardware specification?
My manger is also keen to combine both server on one server to if possible but we not sure if the new server would be able to cope with both server databases.
What are the main consideration to take into account when specificing out new server ? any helpful hints?
we are charity so our resources are limited.
For HA solution we still would be using sql server 2000, as we are not migrating to the newer version of SQL server yet.
Can someone please tells us if they have done something similar in the past.
Many thanks
June 25, 2009 at 3:29 am
Any suggestions any one??
June 25, 2009 at 12:56 pm
To test the performance of existing hardware you can make use of sqliostress utility.
http://support.microsoft.com/kb/231619
For server consolidation search in sqlservercentral forums and you will find some really gud information.
MJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply