| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 17:05:54
|
| How many concurrent active connections on the server? |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-06-01 : 03:35:26
|
| About 700. But what does active connections got to do with worker threads?It's a 64-bit 4-processor server. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-02 : 00:40:27
|
| Each active connection uses a worker thread. |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-06-02 : 12:26:56
|
quote:
Originally posted by rmiao
Each active connection uses a worker thread.
That's not my understanding. Do you have a BOL reference that says that? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-03 : 01:49:46
|
| You can find details in books online. |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-06-04 : 07:26:55
|
| I think you are wrong. From BOL:"Thread pooling helps optimize performance when large numbers of clients are connected to the server. Usually, a separate operating system thread is created for each client connection to consume fewer system resources. However, with hundreds of connections to the server, using one thread per connection can consume large amounts of system resources. The max worker threads option enables SQL Server to create a pool of worker threads to service a larger number of client connections, which improves performance."So each connection DOES NOT use a worker thread like you claimed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-04 : 16:38:25
|
| I didn't say each connectionuse a worker thread. What I said is each ACTIVE connection uses a worker thread, that's concept of pooling. |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-06-04 : 17:32:12
|
| Yes, I know that. But that's not what I asked at the outset:How do you know how many threads are being used and how many of those are being shared? Or whether they are all even being used? Are there PerfMon stats for this? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-04 : 22:52:18
|
| Not as I know of. |
|
|
|
|
max worker threads