MS SQL server shutdown
You may come across the situation where you would not be able to stop the MS SQL service.
I came across very interesting query which can shutdown MS SQL server immediately without waiting for other processes.
Below query runs inside the query analyser of your ms sql server
SHUTDOWN WITH NOWAIT;
Stop using command line
Run => CMD
net stop mssqlserver
This will stop instance of MS SQL server
To start use:
net start mssqlserver
This will start ms SQL server
Afterrestarting the server you may see data base in suspect mode if there exists uncommited transaction.
To bring database online you may require to perform these steps
Bring database online
Don't warry you can recover file from .mdf even if you don't have .ldf file.
MS SQL SERVER CONFIGURATION MANAGER
You can open ms sql server configuration manager as shown in below fig.
Open SQL Server Configuration Manager. Here you can see various sql related services.
Note: Look at the services which you are not using and stop them to avoid unnecessary cpu and memory consumtions.
The services like
1. SQL Server Integration Services (SSIS)
2. SQL Server Analysis Services (SSAS)
3. SQL Server Reporting Services (SSRS)
We rarely use those services as far as development is concerned. Stop them to gain performance of your server.