July 19, 2006 at 2:33 pm
hi all
if a dedicated server is there and if it s installed with sql server 2000.
if more than 100 users are executing a multiple retunable queries at a single instance then the server response will get delayed or ll not respond rit
is there any way to increase the memory of the queries executed at the server
even if more users are using the same database and executing multiple queries the response time should be reduced
how to do this..
tnx in advance
July 21, 2006 at 2:04 am
This is far too big a question to answer in a few lines. Make sure that you have enough memory and disks and that they are properly configured. Make sure that you have indexes in the right places and that your queries are coded efficiently. If you are experiencing issues then you will need to dig deeper to find out where the bottleneck is - there are plenty of resources on the Microsoft website, on sqlserverperformance.com and elsewhere that will help you.
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply