When you start the SQL Server you actually start the Windows service SQL Server and the corresponding process sqlservr.exe.
In addition to starting the server, you also need to start the SQL Server Agent to be able to schedule and execute jobs within the SQL Server Management Studio. Other services offered by the SQL Server are not required in the SAP environment and should therefore not be started.
Overview of SQL Server Services
Service | Process | Comment |
---|---|---|
SQL Server |
sqlservr.exe |
Always required |
SQL ServerAgent |
sqlagent.exe |
Always required |
Distributed Transaction Coordinator |
msdtc.exe |
Do not run in the SAP environment |
FDHOST Launcher |
fdhost.exe |
Do not run in the SAP environment |
You can view a list of all installed services and their current status in the Windows Services application.
You can start the SQL Server using the SQL Server Services manager or the SQL Server Management Studio.
Procedure
The server is started up or shutdown immediately.
During startup, an automatic recovery takes place.
During shutdown a checkpoint is performed in every database.
Never use Pause for a server. This option prevents any further connections being established to the server and may cause SAP errors.
The SQL Server Agent must be started to allow the scheduling of tasks in the SQL Server Management Studio.
Optionally, SQL Server and SQL Server Agent can be started automatically whenever Windows starts. If you wish to implement this option, use the Windows Services application to specify that the services should be started together with Windows. For more information, see the Windows documentation.