Configuring SQL Server 2008 R2
After you have installed SQL Server, you can further configure SQL Server by using graphical and command-prompt utilities. The following table describes support for tools that are used to manage an instance of SQL Server:
Tool or utility |
Description |
|---|---|
SQL Server Management Studio |
SQL Server Management Studio is used to edit and execute queries, and to start standard wizard tasks. For more information, see Introducing SQL Server Management Studio. |
SQL Server Profiler |
SQL Server Profiler provides a graphical user interface to monitor an instance of the SQL Server Database Engine or an instance of Analysis Services. For more information, see Introducing SQL Server Profiler. |
Database Engine Tuning Advisor |
The Database Engine Tuning Advisor helps you to create optimal sets of indexes, indexed views, and partitions. For more information, see Using Database Engine Tuning Advisor. |
Business Intelligence Development Studio |
Business Intelligence Development Studio is an integrated development environment for Analysis Services and Integration Services solutions. For more information, see Introducing Business Intelligence Development Studio. |
Command Prompt Utilities |
You can manage SQL Server objects from the command prompt. For more information, see Command Prompt Utilities. |
SQL Server Configuration Manager |
You can manage server and client network configuration settings. For more information, see SQL Server Configuration Manager. |
Import and Export Data |
Integration Services provides graphical tools and programmable objects to move, copy, and transform data. For more information, see Integration Services Overview. |
SQL Server Setup |
Install, upgrade to, or change components in an instance of SQL Server. For more information, see Installation How-to Topics. |