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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2013-01-07 : 11:32:56
|
| In my activity monitor I see a lot of connections (excess of 100) for a web app but it is not associated with a database?My SQL Server is 2005 but I am useing 2008 Activity Monitor to view connections.My server is showing real slowness and I am trying to figure out why as I see nothing out of the ordinary in profiler.Thanks for any help.R/P |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-01-07 : 11:47:32
|
| Are these connections active or are they ones that have been reset and pooled?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2013-01-07 : 12:32:14
|
| How can I tell? I wouldn't think they would pool that many?/P |
|
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2013-01-07 : 13:29:39
|
| I see in my trace where they are doing connection pooling (2 - pooled)R/P |
|
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2013-01-07 : 14:53:58
|
| Thank you for your help.I will have to look elsewhere to see what my performance issues are.R/P |
|
|
|
lopez
Starting Member
8 Posts |
Posted - 2013-01-17 : 05:08:17
|
| i think the link is very useful for your query have a look at this http://blog.stevex.net/why-is-sql-server-so-slow/ |
|
|
|
|
|
|
Activity Monitor