Duty Free!!

SQL Write-Ahead Overhead…

SQL Server services

Depending on the components that you decide to install, SQL Server Setup installs the following services:

  • SQL Server Database Services – The service for the SQL Server relational Database Engine.
  • SQL Server Agent – Executes jobs, monitors SQL Server, fires alerts, and enables automation of some administrative tasks.
  • Analysis Services – Provides online analytical processing (OLAP) and data mining functionality for business intelligence applications.
  • Reporting Services – Manages, executes, creates, schedules, and delivers reports.
  • Integration Services – Provides management support for Integration Services package storage and execution.
  • SQL Server Browser – The name resolution service that provides SQL Server connection information for client computers.
  • Full-text search – Quickly creates full-text indexes on content and properties of structured and semistructured data to provide document filtering and word-breaking for SQL Server.
  • SQL Server Active Directory Helper – Publishes and manages SQL Server services in Active Directory.
  • SQL Writer – Allows backup and restore applications to operate in the Volume Shadow Copy Service (VSS) framework.

January 22, 2009 Posted by | SQL Server | Leave a comment