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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2010-06-09 : 09:51:59
|
| In my asp.net app, I use ado.net and store procedures. Last night about 10 pm, I ran app and then ran sp_who2. I found that there are so many SPID were generate. Is it some problem in my app?Status:sleepinglogin: sahostname: intranet1dbname: livecommand:AWAITING COMMANDprogramname: .Net SqlClient Data Provider SPID CPUTime DiskIO LastBatch58 0 0 06/08/2010 22:4460 0 0 06/08/2010 22:4462 0 1 06/08/2010 22:4463 0 0 06/08/2010 22:4464 47 37 06/08/2010 22:4869 15 0 06/08/2010 22:4870 0 2 06/08/2010 22:4871 0 0 06/08/2010 22:4857 0 0 06/08/2010 22:4959 0 0 06/08/2010 22:4968 0 0 06/08/2010 22:4972 32 40 06/08/2010 22:4973 0 14 06/08/2010 22:5077 0 0 06/08/2010 22:5078 0 0 06/08/2010 22:5079 0 0 06/08/2010 22:5080 0 5 06/08/2010 22:5181 0 0 06/08/2010 22:5182 15 1 06/08/2010 22:5183 0 0 06/08/2010 22:5184 0 0 06/08/2010 22:5185 0 0 06/08/2010 22:5186 0 6 06/08/2010 22:5187 0 0 06/08/2010 22:5188 0 0 06/08/2010 22:5189 0 0 06/08/2010 22:5174 15 0 06/08/2010 22:5290 16 4 06/08/2010 22:5291 0 0 06/08/2010 22:5292 0 0 06/08/2010 22:5261 0 0 06/08/2010 22:5593 0 5 06/08/2010 22:5565 0 9 06/08/2010 22:5775 0 0 06/08/2010 22:5776 0 0 06/08/2010 22:5794 0 0 06/08/2010 22:5766 0 0 06/08/2010 23:0067 0 0 06/08/2010 23:0095 16 15 06/08/2010 23:00 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-06-25 : 02:16:00
|
| What you are seeing is not unusual. The length of the list will depend on the number of sessions currently connected to the database. Focus on the ones with High CPU , High IO & blocking .Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
How to read sp_who2?