SQL Server Services

SQL Server runs on following services:

SQL Server Service
SQL Agent Service
SQL Browser Service
Full Text Service
MSDTC Service

SQL Server Service:
This is most important service. If this service is running, SQL Server will run. All other services depends on this service. DB Engine run under SQL Server Service.

SQL Agent Service:

Entire automation process run under this service. SQL Agent Service will look at scheduled time of jobs and invoke tasks automatically.

SQL Browser Service:

The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer.

Full Text Service:

Full-Text Search in SQL Server and Azure SQL Database lets users and applications run full-text queries against character-based data in SQL Server tables.

MSDTC Service:

Microsoft Distribution Transaction Co-Ordinator useful for handling distributed transactions from other server.

Powered by k2schools