Posted by Greg D. Moore \(Strider\) on 02/15/07 16:37

"Mark" <analizer1@yahoo.com> wrote in message
news:TI_Ah.14917$O02.4071@newssvr11.news.prodigy.net...
> 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
>

[Back to original message]