bobohost
asked on
Possible to restart single database in SQL Server 2005?
Hello Experts,
I have a SQL Server running about 3 databases. 1 is hit pretty hard from time to time by our data analysts. Every now and then that single database begins to respond very slowly to queries that make it hard to work with. When this happens a reboot of the server after hours will resolve the issue for them. Is there a better way to handle this without rebooting the server or that won't affect the other databases?
I have a SQL Server running about 3 databases. 1 is hit pretty hard from time to time by our data analysts. Every now and then that single database begins to respond very slowly to queries that make it hard to work with. When this happens a reboot of the server after hours will resolve the issue for them. Is there a better way to handle this without rebooting the server or that won't affect the other databases?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER