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 |
|
holymac
Starting Member
13 Posts |
 Posted - 2004-09-09 : 06:22:59
|
| When i connect to the server and go to management and then current activity and then process info i am seeing MANY INSTANCES of a single application having status = sleeping,command = awaiting command and the host are same.There are 3 host running the same application. 1 host has 18 process info, another has more than 25.What does that mean.Network Library they aer using are Named Pipes. What is causing this many process infos. How to reduce it.Will it help if i change the network library to TCP\IPPlease helpThank youKalyana Kumar |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-09 : 08:15:18
|
| It just means that they are keeping connections open. Could be they had a lot of threads running and are waiting for the pooling to drop the connection.Have a look at the last batch time.Try this sp toohttp://www.nigelrivett.net/sp_nrinfo.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Prob:Management -Current Activity - Process Info