Posted by Erland Sommarskog on 02/15/07 22:32

Mark (analizer1@yahoo.com) writes:
> Hi...I have a server that responds to web pages
> and back end processing....im not sure the best place to start to increase
> performance.....
> im a programmer..not a super dba but im pretty good...
> i have two servers at the isp site....was
> thinking of putting all the backen store procedures on one server and when
> there invoked to retrieve the record sets from server1 ....
> looking for some ideas...on how to make this server performance
> increase.....

Have stored procedures on one server and data on another? Really bad
idea from all points of view. More network traffic, and more risk
for things not working at all.

But if you have web server and SQL Server on the same box, it would be a
good idea to separate them.

If you have multiple databases for multiple clients, it could also be
an idea to scale out. Use Profiler to see which databses that get the
most traffic.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]