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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-25 : 13:08:20
|
eli writes "I have a database with many stored procedures that do dynamic sql (puting a code block inside a string @str and then executing with exec (@str)
I noticed that there are many sleeping connections in the database (probably because of that.)
Does many sleeping connections affect performance? if so , Can they be avoided without changing the dynamic code? What is the cause of this behavior by MSSQL?
eli." |
|
|
|
|
|
How to avoid sleeping connections