.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

Jun 15 '06 #1

Subscribe Post Reply

5120

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

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

Similar topics

Export Access Data to Oracle

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

Microsoft Access / VBA

OleDb consumer where is my data source

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

.NET Framework

System.Data.SqlClient "Timeout expired" causing ASP.net web application to automatically restart.

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

ASP.NET

FormsAuthentication and "unable to validate data": HELP!

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')....

ASP.NET

.Net SqlClient Data Provider

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

Visual Basic .NET

SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute

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

ASP.NET

.Net SqlClient Data Provider Error Message

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

.NET Framework

241

Storgae durations

by: jrdacc.i | last post by:

what is the difference between the tree storage durations(static,automatic and dynamic) in C?

C / C++

SqlClient TimeOut Issues In Asp.Net Only

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

ASP.NET

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA