Systems Engineering and RDBMS

SQL Server 2005 Services

Posted by decipherinfosys on July 10, 2007

With SQL Server 2005, there are some additional new services that have been introduced. You can see all of them by running Start/Run and then typing Services.msc and then after pressing enter, take a look at the services listed for SQL Server. You can also take a look at these from the SQL Server 2005 Surface Area Configuration:

img_service_1.jpg

Here is a list of those services and what they do:

  1. SQL Server Database Services: This service is identified with the MSSQLServer name and is an instance based service i.e. one per instance of SQL Server. This is the service that is used for running the relational engine of SQL Server.
  2. SQL Server Analysis Services (SSAS): This service is identified via MSSQLServerOLAPService name and is used for the OLAP and data mining functionality that is provided by SQL Server. If you have chosen not to install SSAS, then of course, this service will not be present on your system. This service is also instance based i.e. one per instance.
  3. SQL Server Integration Services (SSIS): This service is identified by the name MsDtsServer. This is the replacement for DTS (Data Transformation Services) in SQL Server 2000. This is used for providing the complete ETLM (Extract, Transform, Load and Modify) functionality. This is not per instance. This service was introduced in SQL Server 2005.
  4. SQL Server Reporting Services (SSRS): This service is identified by the name ReportServer and is also an instance based service and is used for the configuration of reports, their scheduling and execution.
  5. SQL Server Agent: This is identified by the same name i.e. SQL Server Agent. It is the service that is used for scheduling and executing automated jobs, firing off alerts and automating different SQL Server tasks in the system. This is also an instance based service.
  6. SQL Server Notification Services: This is represented by NS$instance_name which denotes a registered instance of configuring and sending out notifications. This is also an instance based service.
  7. SQL Server Browser Service: This is identified by the name SQL Server Browser. This is not instance based and is used to provide the name resolution to the client applications for the SQL Server instances. This service was introduced in SQL Server 2005.
  8. SQL Server FullText Search Service: This is denoted by SQL Server Full-Text Search and is used for full-text indexes to allow for fast searches on the semi-structured (mostly) data. This is also an instance based service.
  9. SQL Server Active Directory Helper: This is denoted by MSSQLServerADHelper and it is used for integrating with the AD (Active Directory). This is not an instance based service.
  10. SQL Server VSS Writer: This is denoted by the name SQLWriter and is also not an instance based service and is used to provide integration with VSS (Visual SourceSafe). This service was introduced in SQL Server 2005.

Both Reporting Services and Notification Services were also provided as add-ons to SQL Server 2000 in the previous version. Also, you should only run the services that you need – if there are services that are not needed, then do not install those components and if there are services that you do not need to run like the Full-Text Search Service, then stop those.

Sorry, the comment form is closed at this time.

 
%d bloggers like this: