abhidarsh
asked on
database hang
Hi
i use sql server 2000 as a backend for my hospital database. i have two databases. one databse is hanging up every 48 hours or sometimes every 24 hours. i have to restart the MSSQLSERVER servive everytime it will be ok again it reoccurs .no errors are reported in event viewer.users are able to connect to database but they cannot save anything into the database.
other database in the same server is working fine.
is there any issue with the logs.
any help
i use sql server 2000 as a backend for my hospital database. i have two databases. one databse is hanging up every 48 hours or sometimes every 24 hours. i have to restart the MSSQLSERVER servive everytime it will be ok again it reoccurs .no errors are reported in event viewer.users are able to connect to database but they cannot save anything into the database.
other database in the same server is working fine.
is there any issue with the logs.
any help
ASKER
users on the client side cannot save anything into the database.when the client complains me i would restart the service and again they are able to work normal.This problem suddenly started from one week. before everything was fine.
How do i check this blocking.Also when i restart the service i see series of information events in event viewer where i observed four events for other database (which works fine) related to locks and recovery . But i do not see any events related to problamatic database after i restart the service although it works fine for 24-48 hours.
How do i check this blocking.Also when i restart the service i see series of information events in event viewer where i observed four events for other database (which works fine) related to locks and recovery . But i do not see any events related to problamatic database after i restart the service although it works fine for 24-48 hours.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, have you checked for blocking? This is a very common reason for SQL to lockup and would be resolved by restarting the service, although I would not recommend doing that for a simple blocking issue.