Thursday, March 15, 2012

SQL Server Services

From online book.
http://msdn.microsoft.com/en-us/library/ms143504%28v=sql.90%29.aspx
  • SQL Server Database Services - The service for the SQL Server relational Database Engine.
  • SQL Server Agent - Executes jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks.
    ms143504.note(en-US,SQL.90).gifNote:
    For SQL Server and SQL Server Agent to run as services in Windows, SQL Server and SQL Server Agent must be assigned a Windows user account. Typically, both SQL Server and SQL Server Agent are assigned the same user account—either the local system or a domain user account. However, you can customize the settings for each service during the installation process. For more information about how to customize account information for each service, see Service Account.
  • Analysis Services - Provides online analytical processing (OLAP) and data mining functionality for business intelligence applications.
  • Reporting Services - Manages, executes, renders, schedules, and delivers reports.
  • Notification Services - A platform for developing and deploying applications that generate and send notifications.
  • Integration Services - Provides management support for Integration Services package storage and execution.
  • Full-Text Search - Quickly creates full-text indexes on content and properties of structured and semi-structured data to allow fast linguistic searches on this data.
  • SQL Server Browser - The name resolution service that provides SQL Server connection information for client computers.
  • 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.

No comments: