.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server timeout caused by W3wp.exe crashing

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :ASP.Net



I have a ongoing issue with my website, where it appears the W3wp.exe crashes and in turn anyone attempting to connect to the site will receive a SQL server timeout error.


The error is this...


System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


What actually happens is when this occurs, the CPU usage on the server maxes out to 100% and stays there. During this time if I try and connect to the homepage the site will appear to be loading and then timeout. This is also the case when i try and connect to the database through management studio.
I get the above SQL timeout error from ELMAH when it emails me exceptions. When I do a iisreset I can once again connect to SQL server and the CPU usage drops immediately.


Now I have already posted a few questions oh here about the issue in regards to the SQL time out exception. So ill list what I have done and what im using...


  • Im using Linq to SQL.
  • SQLCacheDependancy.
  • IIS 7.5 & SQL Server 2008 R2.
  • Disposing of all objects.
  • The call to the Linq to SQL dataContext is always wrapped in a USING Keyword.


These timeout errors

View Complete Post

More Related Resource Links

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no



 I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.

Thanks in adavance.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]

Timeout polling in server

hi all,           i have done one website and i upload to all file in server..After two day i got error from website starting page Timout error.. too many connections are there so polling timeout.. i dont know how to solve this problem anybody please reply me..

SQL Server Express 2005 connection timeout issue.

Client: Sql Sever Management Studio Express 2005 (SSMSE) on Vista Server: Sql Server 2005 Express on Windows Server 2008 Standard When I first try to log into SSMSE from the client machine, the login operation times out. When I retry, the login succeeds almost immediately. If I close the app and re-open it, the same thing happens. This appears to be infinitely repeatable. I am able to reproduce this behavior using SQLCMD.exe. Here's the error: "Timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)" The technical details reference Error Number -2 What may be unique or tricky about this client's network is that it's a mixture of IPv4 and IPv6. I believe the server is configured for both, but honestly the networking side of things is outside of my expertise. Has anyone else experienced a problem like this? I'm looking for some troubleshooting tips and of course a flat-out answer :-). Thank you in advance for your time and expertise - I hope I've broken the problem down to its simplest form. Will.

SQL SERVER 2008R2 concatenation of CAST causes timeout



In my company, somebody wrote stored procedure that works with MSDE and doesnt work with sql server 2008R2. With 2000 it takes few seconds and with 2008 there is a timeout after 600 seconds.

This is a part where I isolated the problem:


(SELECT TOP 1 MovementHeaderId

FROM MovementHeader )

FROM RetailTransactionLineItemExtended




FROM  Movement


MovementTypeCode ='SALE'


DocumentReferenceTypeCode ='TRANSACTIONLINE'

AND DocmentReferenceCode = cast(RetailTransactionLineItemExtended.TransactionOriginalTransactionID as varchar(20)) +'/'+    cast (Ordinal as varchar(20) ))

And IsPetrol=0


Timeout error from same server but different websites







Hi to all, this is maybe my first time that I have post a question, and it is just because I ran out of ideas... so maybe someone can offer a solution.

First the environment:
OS: Windows Server 2003 R2 - 5.2.3790
Microsoft SQL Server Management Studio        10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft SQL Server Express 2008
Microsoft Data Access Components (MDAC)        2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                    2.6 3.0 4.0 6.0
Microsoft Internet Explorer            7.0.5730.13
Microsoft .NET Framework            2.0.50727.3615
IIS 6.0
Intel Xeon CPU 2.8 GHz, 2.79 GHz, 3.5 GB RAM.

I have a website running on this server let us name: the SiteOne which is physically stored in inetpub, and it works fine. within this site I have a .Net Web Page with nine graphs, it pulls the data from 7 SQL Express queries with the production of the day. Showing the graphs takes to the site 2 seconds the most. However, I was in the need to copy the websi

Server crashing - Access Violation error



Would someone be able to help? We have a major problem with our SQL Server (2008 RC) installation. SQL Server keeps crashing. The key parts of the dump file seem to be these:

Log was backed up. Database: sage_broadata0506, creation date(time): 2010/06/30(13:26:32), first LSN: 18395:3126:1, last LSN: 18395:3126:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\Program Files\Microsoft SQL Server\Backup\sage_broadata0506\sage_broadata0506_backup_2010_10_14_085501_6709455.trn'}). This is an informational message only. No user action is required.
2010-10-14 08:55:03.37 spid61      Using 'dbghelp.dll' version '4.0.5'
2010-10-14 08:55:03.72 spid61      ***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0112.txt
2010-10-14 08:55:03.74 spid61      SqlDumpExceptionHandler: Process 61 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2010-10-14 08:55:03.74 spid61      * *******************************************************************************
2010-10-14 08:55:03.74 spid61      *
2010-10-14 08:55:03.74 spid61      * BEGIN STACK DUMP:

[Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]


Hello All,

I am using MS SQL SERVER 2008. Im making an application which queries trillion of records. Im using PHP as scripting language. For those functions , which query database and 200 (approximately) rows of DB are returned, everything works fine. But if I query database and a large recordset should be returned, the following error is thrown:

Array ( [0] => Array ( [0] => 08S01 [SQLSTATE] => 08S01 [1] => 258

=> 258 [2] => [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]. [message] => [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Timeout error [258]. ) [1] => Array ( [0] => 08S01 [SQLSTATE] => 08S01 [1] => 258
=> 258 [2] => [Microsoft][SQL Server Native Client 10.0]Communication link failure [message] => [Microsoft][SQL Server Native Client 10.0]Communication link failure ) [2] => Array ( [0] => 08S01 [SQLSTATE] => 08S01 [1] => -2147467259
=> -2147467259 [2] => [Microsoft][SQL Server Native Client 10.0]Communication link failure [message] => [Microsoft][SQL Server Native Client 10.0]Communication link failure ) )

If I see the error log it shows:

2010-10-17 12:32:38.88 Logon       Error: 18456, Severity: 14, State: 8.

2010-10-17 12

running SharePoint 2010 and on the server w3wp.exe is consuming huge amounts of CPU and Memory bring


I'm running Server 2008 (64bit) with 8Gig of RAM and 4 processors.  We haven't had more than four people in Sharepoint at the same time and performance has been extremely poor (had moments where things run ok but it usually doesn't last for more than a few minutes).  We're not even doing anything advanced.  Just a very small document repository with basic searching.

When I log into the server I can see several w3wp.exe processes running and will spike up to 100% of the CPU.  Memory will be around 100-800 Mb for each process.

Any ideas on how to speed up SharePoint 2010 performance?  Our SharePoint 2003 box runs MUCH faster and has 100+ users and over 3000 documents???



sqlserver timeout error - corrected by server reboot - how determine cause?


I was gettting multiple timeout errors when submitting changes ( linq to sql ) to my sql server database. This problem occured out of the blue on an app I am coding and testing. Rebooting the client did not correct it. But, rebooting the server did make the problem go away. 

How do I determine what caused the problem. If it happens again, how do I reset things without having to reboot the server?

I am windows server 2008 r2, sql server 2008, VS2010.






How i can set idle timeout in SQL server 2005? In case of Oracle we can set this using profile.

But we don't know how to set in SQL server 2005/

Response from experts would highly help us to proceed our testing.


Thanks in Advance





Sql Server Management Studio Express 2005 keeps crashing


Apologies if this is not the right forum for my topic. I was wondering if anyone could help me with a problem I'm having with SSMSEE. Starting yesterday Management Studio Express kept on crashing whenever I tried to use it. When I first start it, everything looks fine but after opening a new query window the interface starts acting funny like some of the icons disappear and white space starts appearing on parts of the window or a rolling bar graphic appears at the top of window . When I try to run a query on the database I'm connected to the program crashes and the send error report dialog box appears. I've tried debugging the problem using visual studio but all I have is an error message:

An unhandled exception of type 'System.ArgumentException' occurred in Unknown Module.

Additional information: Parameter is not valid.

I've checked the event viewer and the application error records for this issue read:

EventType clr20r3, P1 ssmsee.exe, P2 2005.90.2047.0, P3 443f5ccf, P4 system.drawing, P5, P6 4333aeaf, P7 17e, P8 20, P9 system.argumentexception, P10 NIL.

I've tried uninstalling and reinstalling Management Studio but the problem still persists. I've also tried uninstalling and reinstalling .NET Framework 2.0 and it didn't help. I have googled for people who have encount

High CPU Utilization of w3wp.exe and Event ID 5000 caused by Search


Hello, I am trying to trouble shoot an issue related to my SharePoint server having the CPU pinned down by w3wp.exe.  The only exception I was able to identify has been related to Search.

Event ID 5000 Office SharePoint Server


EventType ulsexception12, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435e74, P4 microsoft.office.server.search, P5 12.0.6245.0, P6 4bbd6526, P7 3012, P8 191, P9 deletedconcurrencyexception, P10 837s.

I am having no luck with any of the codes as part of this error message.  Could any one point me in the right direction related to Event ID 5000 ulsexception12.  To my knowledge there have been no changes made to Search or SSP.

Any help would be greatly appreciated.  thank you

Mark A. Eckert SharePoint Consultant Pharmica Consulting, Inc.

Server timeout error



I have added a report web part in a Share Point site. Report viewer is pointing to report which is inside the report library of site. I am getting server timeout error if query is taking more than 90 seconds. I have changed the script timeout in IIS settings to 00:05:30 (330 seconds), still error is shown after 90 seconds.

Timeout or terminate WaitForConnection in a server NamedPipe - .Net 3.5


.Net 3.5 My communication between the application server and various clients (on other machines)  via Named Pipes is generally okay, but what if the client (the small app that is listening on the named pipe) is not up and running? The application on the server has many responsibilities and having it wait forever to send info via the pipe to a particular client is not acceptible.


pipeIO = new NamedPipeServerStream(pipeName, PipeDirection.InOut); pipeIO.WaitForConnection();

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.

jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend