V7 Profiler Trace Results - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

V7 Profiler Trace Results

Author

Topic

earsby
Starting Member

3 Posts

Posted - 2007-01-17 : 06:37:39

Hi,

I have run my a Profiler Trace as our users are reporting speed issues.

The results look mostly ok. Simple and complex queries are being handled in 50-250 ms.

However, just beneath the query itself, there is the line 'ExistingConnection'. Often this figure is 400,000 ms plus!

What is this 'ExistingConnection' doing exactly? And any reason this could be so high?

We are invesgating other possibilities such as line and capacity issues but the pressure is on! Nothing extraordinary has happened with database structures, size or queries since it was running fine.

Any advice much appreciated.

Thanks,

Greig

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-17 : 07:13:30

I think ExistingConnection is the number of milliseconds the connection has been "on".
In your case, some 400 seconds which is about 6.5 minutes

Peter Larsson
Helsingborg, Sweden