| Author |
Topic |
|
KazaX
Starting Member
28 Posts |
 Posted - 2008-10-30 : 21:48:27
|
| Hi there, Why it is generally not possible to set a limit on the time taken by server, that carries out clients requests without accessing other servers, to respond to a client request.How to manage that a server be able to execute requests within a bounded time? Is this a practical option? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-10-31 : 01:25:56
|
There is already such limits and thats why you get into time-out errors  |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2008-10-31 : 02:19:30
|
| U can set time limit as per ur requirement.malay |
|
|
|
KazaX
Starting Member
28 Posts |
Posted - 2008-10-31 : 19:28:16
|
Hello Folks!thax 4 repliesBut it is not particular to query optimization or db structure. Any client request to a server which is not accessing other servers, and it is the fact that it is generally not possible to set a limit on time taken to respond to client request. Think simple. Any ideas appreciatedthx in advance  |
|
|
|
KazaX
Starting Member
28 Posts |
Posted - 2008-10-31 : 19:29:48
|
quote:
Originally posted by KazaX
Hello Folks!thax 4 repliesBut it is not particular to query optimization or db structure. Any client request to a server which is not accessing other servers, and it is the fact that it is generally not possible to set a limit on time taken to respond to client request. Think simple. Any ideas appreciatedthx in advance
Sorry forgot the question why is not possible ? :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
KazaX
Starting Member
28 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
KazaX
Starting Member
28 Posts |
Posted - 2008-11-03 : 08:01:10
|
quote:
Originally posted by tkizer
None of us here have the ability to change the SQL Server functionality. If you want the functionality added, then you should contact Microsoft (sqlwish at microsoft dot com).Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
The rate of arrival of client requests is unpredictable.If the server uses threads to execute the requests concurrently, it may not be able to allocate sufficienttime to a particular request within any given time limit.If the server queues the request and carries them out one at a time, they may wait in the queue for anunlimited amount of time.To execute requests within bounded time, limit the number of clients to suit its capacity. To deal with moreclients, use a server with more processors. After that, (or instead) replicate the service....The solution may be costly and in some cases keeping the replicas consistent may take up useful processingcycles, reducing those available for executing requests. |
|
|
|
|
Execution time question