What Services Created By SQL Server Installation

Service Created By SQL Server

Microsoft SQL server is one of the best database system in the business. This short post only gonna show you what services, how many of them are SQL server Express is created during the installation process. Here's list of SQL server express services:

SQL Server
The core of SQL server

SQL Server Agent
Schedules jobs and handles other automated tasks.

SQL Server Browser
Listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer

SQL Server CEIP service
CEIP - Customer Experience Improvement Program is a program designed to collects your computer statistics information and how people use SQL server, useful for Microsoft to improve SQL server n the future and solving the problem if the SQL server somehow not working or crash. It is running automatically when our computer started,

SQL Server VSS Writter
Backup and restore of SQL Server through the Volume Shadow Copy Service framework. It is running automatically when our computer started,

Those services is essentials for SQL server to be running smoothly, so if you don't need them, just disabled it, but never remove them.

For development process, we can install SQL server express edition, because the actual SQL server it is not a free program, the SQL server express is the free one. But don't worry, it has same capability, it just limiting its maximum database size only 10 GB per database, SQL server agent is not included, etc.

Popular posts from this blog

ERROR 1348 Column Password Is Not Updatable When Updating MySQL Root Password

Spring Kafka - how to use ReplyingKafkaTemplate send and reply synchronously

How To Connect SSH Using PEM Certificate On Windows

Upload and Download Rest API using Spring Boot Reactive WebFlux

MIME Types - Complete List