SQL Server Breaks down for every 10mins

Question

SQL Server Breaks down for every 10mins

Viewing 5 posts - 16 through 19 (of 19 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Just from the error log, there's a number of configuration and maintenance problems on this server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

andrew gothard SSChampion Points: 12315 More actions · Answer 2

Have you tried starting Task manager on the server and seeing if there's a process eating memory?

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

pinnamaneni.pavani

could you provide info from the cluster.log

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 4

GilaMonster (10/30/2010)
Jeff Moden (10/30/2010)
GilaMonster (10/29/2010)
p.s. The last integrity check of any of these databases was almost 2 years ago. You like living dangerously?
That actually brings up a good subject. Do you happen to have a recommended link for what to do if an integrity check fails?
Absolutely. http://www.sqlservercentral.com/articles/65804/

Heh... DOH!!! 😛 I should have thought of that one. Thanks, Gail.

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

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 5

Perry Whittle (10/30/2010)
Jeff
There isn't really any hard fast link for a fix, it depends what the failure is. Each situation is taken on it's own merit.

Heh... nah... Gail is a "Ninja" at this stuff. I knew that if she hadn't actually written one herself, she'd be able to point me to one. She's done it a couple of times in the past, now.

Gail, thanks again.

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