sql server programming: Im a newbie. I have read many posts similar to this one, but I think this one is unlike others.

I run the profiler and see that there is an Audit Logout event class with no TextData description.
The exec step usually is 4-20 reads.

But the Audit Logout step takes around 5 million reads and 3.5 million writes!. When I copy the
exec statement from the profiler and execute it within Service Management Studio, it takes no time.

What could be going on here?

Thanks, Flomo



RPC:Completed exec sp_reset_connection .Net SqlClient Data Provider larry MARSYS\larry 0 0 0 0
3728 54 2007-07-14 13:19:36.650 2007-07-14 13:19:36.650
0X00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00
Audit Login -- network protocol: LPC
.Net SqlClient Data Provider larry MARSYS\larry 3728 54 2007-07-14 13:19:36.650
RPC:Completed exec usp_Address_Exists_UQ_House_Location
@StreetName=N'Marine',@HouseNo=N'1406',@City=N'Santa
Monica',@PreDir=N'',@StreetSuffix=N'St',@PostDir=N'',@State=N'CA',@Zip5=N'90405',@Zip4=N'5817',@Sud=
N'',@UnitNum=N'' .Net SqlClient Data Provider larry MARSYS\larry 0 4 0 11 3728 54 2007-07-14
13:19:36.650
Audit Logout .Net SqlClient Data Provider larry MARSYS\larry 0 49307054 36379 13 3728 54
2007-07-14 13:19:36.650 2007-07-14 13:19:36.663
--

The reads, writes and cpu are the accumulated totals for the connection
not for the logout event itself.

Hi Flomo,
The reads and writes values are not related to a single statement execution
time since the reads and writes values in SQL Profiler just mean logical
reads and writes issued by the user during the connection. They are numbers
of total logical read/write I/Os of a connection. If a connection exists
for a long time and has many activities, the reads and writes values will
be large.
You may refer to:
Audit Logout Event Class
http://msdn2.microsoft.com/en-us/library/ms175827.aspx

Please feel free to let me know if you have any other questions or
concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Hi,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================