Problem with on specific database

[rsoxhater]

We have our main sql server with a bunch of databases on it. Everything has been running fine for a long time (year or so) without any major changes to the server. Over the last week, one specific program keeps losing its connection to the server - noone can log into the program or anything. As soon as I restart SQL service on the server the program starts working fine again. No other database on the server (some which are used much heavier than this one) ever have any problems.

Server specs: Win2kSP4, Dual Xeon 2.8 , 4 gigs of ram. It also runs our exchange server. Nothing else on this server has any problems.

The program in question has not been updated in the last month at least. No new programs have been installed on the server in the last month or so.


How can I find out why this one specific database stops responding to requests?

 

[mrdenny]

It could be a locking problem. When the problem starts happening run the sp_locks and see what shows up. Also run sp_who2 and see if any queries are blocked.

Are you doing regular database maintenance on the server? If so what maintenance are you going?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[rsoxhater]

I will try that next time the problem occurs. No, no regular maintanence on SQL - what should we be doing?

Thanks

 

[mrdenny]

You should be doing regular optimization and integrity checks on the database. You can either your the maintenaince plans, or the DBCC commands directly; which ever you are more comfortible with.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)