Sunday, July 15, 2018

Instance Aware & Unaware Services



1. Instance Aware Services

Instance-aware services are associated with a specific instance of SQL Server, and have their own registry hives. We can install multiple copies of instance-aware services by running SQL Server Setup for each component or service.

i.e.
1. SQL Server
2. SQL Server Agent
3. Analysis Service
4. Reporting Service
5. Full-text search


2. Instance Unaware Services

Instance-unaware services are shared among all installed SQL Server instances. They are not associated with a specific instance, are installed only once, and cannot be installed side by side.
i.e.
1. Integration Services
2. SQL Server Browser
3. SQL Server Active Directory Helper
4. SQL Writer

No comments:

Post a Comment

SQL Server Architecture

SQL Server Architecture can be divided into two parts: Storage Engine & Relational Engine Relational engine three different compon...