I have multiple databases on the same sql server 2008. Some times the server stops working and I should restart it to make it work again. Is there an easy way to know which application or website caused this stop?
Or can I know which database takes the most of the server power?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
||||
|
|
|
1) Computer was restarted (one of causes). Use Sql Server Configuration Manager to set Start Mode to Automatic
2) Use Event viewer (Windows Logs/System) to get more information about stops/starts of service:
|
|||
|
|
