By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Performance

P: n/a
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.....

thanks
Mark
Feb 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Mark wrote:
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 ....
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.
Feb 15 '07 #2

P: n/a

"Mark" <an*******@yahoo.comwrote in message
news:TI******************@newssvr11.news.prodigy.n et...
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.....
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

Feb 15 '07 #3

P: n/a
Mark (an*******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.