|
Explain SQL Server Service Manager.- It is used to start, stop, and pause SQL Server services that exist as the separate components on the server.
The service components are as follows:
1. SQL Server Service
2. SQL Server Agent Service
3. Microsoft Search Service
4. MSDTC Service
5. MSSQLServerOLAPService Service
- These components are run as a service on windows NT and 2000.
- SQL Server Service Manager separates executable programs on windows 98.
1. SQL Server Service:
- It implements the SQL server database engine.
- There is one SQL server service for each instance of SQL Server running on the computer.
2. SQL Server Agent Service:
- It implements the agent that runs scheduled SQL Server administrative tasks.
- There is one SQL Server Agent service for each instance of SQL Server running on the computer.
3. Microsoft Search Service:
- It implements the full-text search engine.
- There is only one service, regardless of the number of SQL Server instances on the computer.
- This service executes only on windows NT and 2000.
4. MSDTC Service:
- It manages distributed transactions.
- There is only one service, regardless of the number of SQL Server instances on the computer.
- This service executes only on windows NT and 2000.
5. MSSSQLServerOIAPService Service:
- It implements SQL Server 2000 analysis services.
- There is only one service, regardless of the number of SQL Server instances on the computer.
- This service executes only on windows NT and 2000.
|
