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 |
|
junior.carls
Starting Member
7 Posts |
 Posted - 2008-12-05 : 14:05:46
|
| Hi All,I am having an issue with a vendor that I was hoping you could help me out with. We purchased an application for a vendor that connects to our SQL Server cluster. The certain modules of application have been perfroming poorly... long wait times and what not. The vendor is now comming back to us say that the cluster could be causing these issues. No other aplication on our cluster is having any performance issues, which we have told the vendor. The vendor has come back and said that a clustered environemtn will cause the application to perform slower than on a dedicated stand alone SQL server because the application is so query intensive. My understanding is that a SQL cluster is not only more reliable in terms of high availability, but also has huge performance benifiits.Am I way off here. Is the vendor right... can the application actually perform worse in a clustered environment? If so, are there things we can do on the cluster to improve the performance of this application?I do not know that much about clustering in SQL Server, so sorry f the question seems rather elementry.Cheers |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-12-05 : 14:34:59
|
| The vendor is absolutely wrong about a cluster performing slower than a standalone box. I wouldn't say that a cluster has huge performance benefits though. I know a lot about clustering. We have about 10 clusters here. Most are 2-node clusters, we also have a couple of 4-node clusters. Some clusters have all nodes being active. We have high availability and performance requirements here. We take performance very seriously.Your vendor has idiots working for them if they think that a cluster is slower. It shows their lack of knowledge of clustering as well as SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Application Performance