.NET SqlClient Data Provider generating long durations

[John Bailo]

I'm doing a profile on my SQL Server to see if I can eliminate any long
running statements, and periodically, I see an entry for ".NET SqlClient
Data Provider". The durations for it are very long, the example below
shows 386 seconds!

I would think that whatever these are they are "gumming up" my database
server. However, there is nothing in the Text Data field to help me
identify the source!

Does anyone else get this showing up in their SQL profile?




Audit Logout

..Net SqlClient Data Provider
sa
0
10
0
380226
0
61
2006-06-15 15:38:47.050

Audit Login
-- network protocol: TCP/IP
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7
..Net SqlClient Data Provider
sa
0
61
2006-06-15 15:45:07.293

 

[John Bailo]

I'm finding even longer durations running through my trace.

That's 60679 reads and a duration of 1380356ms (1380 seconds, or 23
minutes).

Can I get profiler to tell me what's generating this and the other one,
a whopping 391 seconds?




Audit Logout .Net SqlClient Data Provider sa 3032 60679 0 1380356 0
63 2006-06-16 10:26:39.810
Audit Logout .Net SqlClient Data Provider sa 0 40 0 391916 0 61
2006-06-16 10:43:12.127