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 |
|
sdp
Starting Member
12 Posts |
 Posted - 2010-09-16 : 16:27:18
|
Hi all,I've google'd this for hours and I'm getting absolutely nowhere.Firstly, I understand that the duration of "Audit Logout" is the total time a user is connected, and it's normal for this to be a high value.We have an ASP.Net page that is taking a long time to execute (approximately 2 seconds). It calls several (~30) stored procedures.Running profiler shows us that all of the procedures seem very efficient (<10ms). However, on a couple of the procedures the time difference between Audit Login and Audit Logout can be ~500ms, even though the query between them took just a few ms to execute.I've attached a picture to illustrate what I mean. Why is the highlighted area taking 400ms to complete? It's making the page very slow.http://simonpooley-co-uk.php5.hostingweb.co.uk/profiler.pngAny help is much appreciated! I'm totally stuck! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sdp
Starting Member
12 Posts |
Posted - 2010-09-17 : 02:42:06
|
| Our data gateways connect and disconnect on each method, it's never caused any issues in the past. I don't think it's the logout thats necessarily causing the lag - is it possible there's some activity occurring thats not being picked up on the trace? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-18 : 02:47:19
|
| Is there a (large) data resultset from the Sproc (that has to be consumed before the Logout can occur?)However, as Tara says, my preference too would be to connect once, run 30 Sprocs, and then disconnect. Over the years I have experienced horrific lag problems on DB Connect. Maybe solved in the many releases of database and LAN upgrades since, but they still haunt me ... |
|
|
|
|
|
|
|
|
SQL 2008 Profiler - Audit Logout (Performance)