468,249 Members | 1,488 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

.NET SqlClient Data Provider generating long durations


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
Jun 15 '06 #1
1 4851

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


John Bailo wrote:

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

Jun 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew Arace | last post: by
1 post views Thread by Duncan Winn | last post: by
2 posts views Thread by Harrie Verveer | last post: by
2 posts views Thread by rufus | last post: by
2 posts views Thread by =?Utf-8?B?Y2hpZWtv?= | last post: by
241 posts views Thread by jrdacc.i | last post: by
7 posts views Thread by =?Utf-8?B?a19tYW4=?= | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.