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?
Sql-server – How to know which website is causing the sql server to stop responding
sql-server-2008
Related Question
- Sql-server – Design SQL Server 2008 new install … which collation
- Sql-server – Should the host machine always be restarted after upgrading an SQL Server 2008 instance
- Sql-server – how does SQL Server know to lock view objects
- Sql-server – SQL Server connection from iis website: “error: 26 – Error Locating Server/Instance Specified”
- Sql-server – somehow ignore uncomitted transactions which are causing the database to go into recovery
- Sql-server – How to determine which tables are causing the database to grow over time
- SQL Server 2008 – Retiring an Instance Without Impacting Primary Server
Best Answer
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: