Search This Blog

Sunday, September 15, 2013

SQL Server 2012 Services

Services are applications that start without user interaction, normally at computer startup.
Main services in SQL Server 2012:

SQL Server 2012 database engine is responsible for executing commands submitted in the
Transact-SQL, T-SQL, language, database management, memory and disk allocation.

SQL Server Agent is responsible for executing scheduled jobs, monitoring the system and other administrative tasks.

Business intelligence include SQL Server Reporting Services, SQL Server Analysis
Services, and SQL Server Integration Services.