SQL Server Performance Forum – Threads Archive
Dynamic Website is slow with SQL Cluster
Hello. My first post so be easy with me <img src=’/community/emoticons/emotion-5.gif’ alt=’![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
If I understand you correctly, you have a database running on a cluster that appears slow to you when you run your website app against it. But if then switch your website app to a non-clustered server, the website app runs faster? Is this correct? Assuming the above is correct, you first must ensure that you are testing apples to apples. In other words, are the hardware virtually identical, is SQL Server configured exactly on both systems, is the database identical on both systems? But your testing may not be the issue. What I would do first is to perform a performance audit of your cluster and web app, as described on this website. This will catch any basic issues. Next, do a Profiler trace to identify all long running queries, and then analyze them, one at a time, until you identify, and correct, any slow running queries. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
Also, can you confirm that when you are saying that you tested it on a desktop, you are not saying that both the IIS server and the database were running on the desktop. This again would be a major difference, which depending on the application architecture can have a significant implication Cheers
Twan
<br /><br />Yes the test system is a desktop machine. I do not have a spare same server to compare it with <img src=’/community/emoticons/emotion-2.gif’ alt=’
![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
The IIS box is connected to both SQL servers the test and the clustered. This is to refrain from the IIS box being a problem in the equation.
To get optimum performance its better to seperate IIS and SQL server and not to keep on the same server. BTW what is the level of service packs on SQL, IIS & OS? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi ya, Ok well if the only difference that you can think of is the database being on different hardware, then you’ll have to follow Brad’s suggestion of using Profiler and perfmon to compare the performance on the two machines. In perfmon check for the obvious things first, memory, disk, cpu, network. There has to be something that is not configured optimally or not functioning correctly… you could try comparing a file copy from the desktop to the webserver and the server to the webserver to make sure that there is no straight network connectivity issue (which could be misconfiguration or a network card problem) Good luck
Twan
When you transfered the database into the cluster did you do it with a backup/restore? If so did you run sp_updatestats on the database afterwards? Edit:
oops, didn’t see it was an old topic. /Argyle
]]>