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-09-21 : 10:08:35
|
| Shay writes "Hias part of checking my sql7.0 performance I noticed that some functions in the application (written in magic) which "digs" info from the sql acts in the following manner:when a user activates asearch query on the database (looking for aspecific customer in some tables )the profiler trace shows that during this query there are many connect and disconnect statments (few of them in one second).is it normal? or is it abad application design? does it "heart"performance ? if it is aproblem what can be done to improve the queries ?Thanks" |
|
|
|
|
|
connect and disconnect appears rapidly in profiler trace