Database server. I am using sp_who and looking at the number of rows
returned. I assume that each spid is a connection.
"Vinodk" <vinodk_scthotmail.com> wrote in message
Looking at the server characteristics I suppose this worker process threads
is in consequential as far as your database is concerned. They seem to work
for maximum throughput ... And when you say by 1700 concurrent connections
are you looking at the web server or the database server. For all you know
even if the web server says 1700 concurrent connections there maybe just
100~200 connections made to the database. Lets see what others have to say
on this ...
MCSE, DBA, MCAD
SCT Software Solutions
"Bob Castleman" <nomailhere> wrote in message
news:uLOj5MKQDHA.2432TK2MSFTNGP10.phx.gbl...hit> I just read an article on the setting of Max work threads to more than the
> default of 255. I was curious what experience anyone has had with this in
> regard to performance. Currently our server is running 99% buffer/cacheconnections> ratio and %30 CPU utilization. We average about 1700+ concurrent> at peak times. This would imply significant use of thread pooling.
> Any thoughts would be appreciated.
> Bob Castleman
> SuccessWare Software