473,287 Members | 1,659 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

.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 5141

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Andrew Arace | last post by:
I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in this case, it was oracle 8i but i'm assuming this...
1
by: Duncan Winn | last post by:
I have generated an OleDB provider from MS VC++ 7 ATL templates. I have modified this using Lon Fishers tutorial! (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvc60/htm...
2
by: Chris Langston | last post by:
I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET ...
2
by: Harrie Verveer | last post by:
Hi, I'm building quiet a large webapplication (CMS) in ASP.NET. On localhost the application runs fine. For publishing we use 2 hosting providers at the moment (let's call those 'A' and 'B')....
2
by: rufus | last post by:
Hi, My vb.Net program is copy files from one network location to another, because these are quite large files it takes hrs and i keep getting a timeout expired error message from the the data...
2
by: =?Utf-8?B?Y2hpZWtv?= | last post by:
Hello, We recently converted from ASP.net 1.X to ASP.net 2.0 application. Since then, we randomly get the SQL errors when the function tries to get records from SQL. We are using stored...
2
by: bguthals | last post by:
Recieved the following error message. I'm not familiar with .Net and my co-workers haven't seen this error before. Maybe someone can clue me in on what is the problem. .Net SqlClient Data...
241
by: jrdacc.i | last post by:
what is the difference between the tree storage durations(static,automatic and dynamic) in C?
7
by: =?Utf-8?B?a19tYW4=?= | last post by:
Hi all, Have a strange problem with SqlClient timeouts. Here is some background: About a month ago I upgrade from SQL 2000 to 2008. Am using Stored Procedures for all the data access. Most of...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.