Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sweetraskels
Starting Member
2 Posts |
 Posted - 2006-07-19 : 16:26:38
|
| hi allif 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 ritis there any way to increase the memory of the queries executed at the servereven 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-19 : 16:55:32
|
| You can't increase the amount of memory for a particular query. I don't understand the rest of your post.Tara Kizer |
 |
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2006-07-19 : 17:26:26
|
| First of all... try to understand and optimize the queries. Use Indexes and SPs to help you. |
|
|
|
sweetraskels
Starting Member
2 Posts |
Posted - 2006-07-19 : 23:52:22
|
| if more people are accessing the same database then the performance ll be slower rithow to increase the performace and not let to server down even if more pepople are accessing the server |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-20 : 00:57:07
|
| if you mean dedicate cpu or ram to a particular query, not possibleyou need to evaluate if there is network traffic, bandwidth is enough, query response time, server capacity, latencies, query optimization etc to improve query performanceHTH--------------------keeping it simple... |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-07-24 : 03:35:16
|
| most likely you will need to look into your query, if its returning like mil and mil of records and your network speed is not fast enough, I don't think anyone can fix that :) |
|
|
|
|
|
|
administration help please