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 Overview (Integration Services).
|
|
SQL Server Setup
|
Install, upgrade to, or change components in an instance of SQL Server. For more information, see Installation How-to Topics.
|

See Also