Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicklaz
Starting Member
3 Posts |
 Posted - 2009-06-27 : 14:32:53
|
| my company is running a stand alone sql 2008 server for our ERP. we would like to implement some kind of HA but want to take as little a performance hit as possible. we're currently thinking about an active/passive cluster with a shared SAS array. would our ERP take a performance hit in this type of configuration? if so, can you explain how/why the performance is impacted? is there a better recommendation for implementing HA with less of a performance impact?thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nicklaz
Starting Member
3 Posts |
Posted - 2009-06-29 : 23:46:31
|
| are you saying that there is no performance hit whatsoever (cpu, memory, sotrage, etc)?is that true with any type of cluster or just active/passive? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-06-30 : 13:06:59
|
| We run active/active and active/passive on ALL of our production systems. Every single one of them is on a cluster. There is no performance hit with this HA approach, but if you run multiple instances on the same node then you need to make sure the hardware can support it. This is no different than a standalone server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
noneil277
Starting Member
13 Posts |
Posted - 2009-07-24 : 09:27:29
|
| I concur with Tara, there is no performance hit unless you are running multiple instances on the same node.--Nicholas O'NeilSenior Engineer, Logicworks.netMCSA/MCSE/+Messaging/MCTS:SQL2005 |
|
|
|
|
|
|
performace hit of HA