473,326 Members | 2,337 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,326 software developers and data experts.

Coping with slow SQL Servers in ASP.NET

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
Feb 1 '08 #1
3 948
Hello Microsoft,

You need to use Performance counters or profiler to understand system bottlenecks
first

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
MNHi,
MN>
MNWe have situations occasionally where the SQL server is extremely
MNslow to respond. The problm is that the user is left with loading
MNpage and has no idea what in heaven is going on.
MN>
MNDoes anyone have any ideas how the DAL can be confiured to timeout
MNand throw an exception if the response is not quick enough ?
MN>
MNCheers
MN>
Feb 1 '08 #2
"Microsoft Newsserver" <me@nowhere.comwrote in message
news:OT**************@TK2MSFTNGP06.phx.gbl...
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 ?
You're trying to fix the wrong problem!

You should be looking at why the database query is so slow and fixing
that...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Feb 1 '08 #3
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@nowhere.comwrote in message
news:OT**************@TK2MSFTNGP06.phx.gbl...
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


Feb 1 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: B B | last post by:
Okay, here is what's happening: I have a reasonably fast laptop (1.4 GHz Mobile M, so comparable to 2.5GHz P4) doing .net development. Running Windows XP pro, SP2 IIS is installed and running...
4
by: sommes | last post by:
It's only happen on .asp website, what's the problem? Thank you
10
by: penworthamnaynesh | last post by:
Does php slow your website down? This is what i would like to know.The reason is because my site is writtent 50% in html and 50% in php and is very slow at loading. And i cant tell wether php is...
4
by: con | last post by:
Hi All, I have a asp.net web site with vb.net back end, when I connect to the MS sql 2000 server via ado.net it takes a long time to connect to ms sql >25sec. Addressed sql server via ip, full...
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: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.