Eliminating Timeouts

Question

Eliminating Timeouts

sqlislife

Ten Centuries

Points: 1251
More actions
March 12, 2010 at 5:24 pm

#230770

How can a midsized company such as ours go about eliminating timeout caused by users. Is it possible? Anything causes timeouts from jobs running simultaneously as server requests to locking e.t.c. Any input would be nice. The company is growing and we are currently looking at ideas and strategies to go about this.
I wanted to rub minds with the professionals on here before I proceed. Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

sqlislife (3/12/2010)
How can a midsized company such as ours go about eliminating timeout caused by users. Is it possible? Anything causes timeouts from jobs running simultaneously as server requests to locking e.t.c. Any input would be nice. The company is growing and we are currently looking at ideas and strategies to go about this.
I wanted to rub minds with the professionals on here before I proceed. Thanks

There's only one way to do this... fix the bad code and the bad indexes. And, make no doubt about it, it's because of bad code and bad indexes. For users using ad hoc queries, build a reporting server that they can use. The best fix would be to hire a really good DBA and then give him/her the authority (s)he'll need to fix things for you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 2

Just to pile on a bit, I'm with Jeff. It sounds like your architecture, your structures, and your code are to blame. You need to get someone in who can identify the causes of the problems and offer viable solutions and then implement those solutions.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

sqlislife Ten Centuries Points: 1251 More actions · Answer 3

Thank you very much for your responses. They have been taken into consideration.