Performance

[Mark]

Hi...I have a server that responds to web pages
and back end processing....i m 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.....

thanks
Mark

[Ed Murphy]

Re: Performance

Mark wrote:

Hi...I have a server that responds to web pages
and back end processing....i m 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 ....

You want to minimize the amount of data that has to travel over the
network connection between the servers. I'd put all the SQL stuff
(tables and stored procedures) on one server, all the web front-end
stuff (HTML/ASP/PHP/whatever and images) on the other.

looking for some ideas...on how to make this server performance
increase.....

Memory is faster than disk is faster than network, so:

1) Maximize RAM. There's some slightly non-trivial configuration
involved in getting SQL Server to use more than 2 GB. But don't
let it use quite /all/ the RAM, you need to leave some for the OS.

2) Optimize disk usage. Ideally, keep data, temp, logs, and other
stuff (including the OS) separate. Someone more familiar with
the different types of RAID can chime in here.

3) Minimize network traffic. Filter data server-side, unless the
ugliness of the resulting code outweighs the speed gain.

[Greg D. Moore \(Strider\)]

Re: Performance


"Mark" <analizer1@yaho o.comwrote in message
news:TI_Ah.1491 7$O02.4071@news svr11.news.prod igy.net...

Hi...I have a server that responds to web pages
and back end processing....i m 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.....

Find the bottleneck.

There's some good books and articles out there on performance tuning. But
figure out if you have lots of disk I/O, CPU or what.

Are your tables properly indexed for example? If not, that's a good place
to look for example.

>
thanks
Mark
>

[Erland Sommarskog]

Re: Performance

Mark (analizer1@yaho o.com) writes:

Hi...I have a server that responds to web pages
and back end processing....i m 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@sommarsk og.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