Re: Coping with slow SQL Servers in ASP.NET
- From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Feb 2008 10:52:39 -0600
You can time out the query, but I would find out why you are having the
problem first.
Step 1 is to run performance counters and see what is happening
Then, you will likely find out which queries are your problem child and fix
them. Followed by possibly adding or correcting indexes. Or moving to a
stronger box, as you have outgrown the box you are running SQL on.
Throwing in the connection timeout will let you tell the user the server is
too busy, but it will not solve the problem.
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
*************************************************
| Think outside the box!
|
*************************************************
"Microsoft Newsserver" <me@xxxxxxxxxxx> wrote in message
news:OTpCRsLZIHA.4684@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
We have situations occasionally where the SQL server is extremely slow to
respond. The problm is that the user is left with loading page and has no
idea what in heaven is going on.
Does anyone have any ideas how the DAL can be confiured to timeout and
throw an exception if the response is not quick enough ?
Cheers
.
- References:
- Coping with slow SQL Servers in ASP.NET
- From: Microsoft Newsserver
- Coping with slow SQL Servers in ASP.NET
- Prev by Date: Re: vs2005
- Next by Date: Re: Visual Studio 2005 Team edition for Software Developers and Web Site
- Previous by thread: Re: Coping with slow SQL Servers in ASP.NET
- Next by thread: Re: AJAX 3.5 ToolKit & IE6?
- Index(es):
Relevant Pages
|
