Overview of SQL Server database management

"DBA Common management Tools"

SSMS, BIDS, SQL serverprofiler ...

One, SQL Server common management tools

1. SQL Server Management Studio

Used to access, control, manage, and develop all of the components of SQL Server, such as editing and executing queries, and starting standard wizard tasks.

2. SQL Server Profiler

Provides a graphical user interface for monitoring an instance of a SQL Server database engine or an Analysis Services instance.

3. SQL Server Database Tuning Advisor

You can help create the best combination of indexes, indexed views, and partitions.

4. Business Intelligence Development Studio

An integrated development environment for Analysis Services and integrationservices solutions.

5. SQL Server Configuration Manager

Manage server and client network configuration settings.

6. Command prompt utility

Managing SQL Server objects from the command prompt, such as Osql.exe and SQLCMD.exe

7. Import and Export data

Provides a set of graphical tools and programmable objects for moving, copying, and transforming data.

8. SQL Server Setup program

Install, change, or upgrade components in an instance of SQL Server.

(1), SSMs Introduction

"Features implemented by SSMs"

[Registration Server

[Connect to an instance of the database engine, Analysis Services, Integration Services, Reporting services, or SQL Server Compact 3.5

[Manage databases and Analysis Services objects such as cubes, dimensions, and assemblies]

[Create objects such as database tables, libraries, cubes, database users, logins, and so on

[Managing Files and Filegroups

[Attach or detach a database

[Startup Scripting Tools

[Manage Security

[View System Log

[Monitoring Current Activity

[Configure Replication

[Manage Full-text indexing

[Start or stop SQL Server Agent

(2), Bids introduction

BIDS (businessintelligence Development Studio) is a visual Studio tool that is the primary environment for developing business solutions.

1, the analysisservices in the bids

Analysis Services Project for developing online analytical processing (OLAP) and data mining capabilities for business intelligence applications

2, the integrationservices in the bids

Integration Services Project for developing ETL Solutions

3, the reportingservices in the bids

Bids includes report model projects and report projects for developing report solutions

(3), SQL Server Profiler Introduction

The Vsql Server Profiler is a graphical user interface for SQL tracing, which is used to monitor instances of the database engine or analysis Server

V can capture data about each event and save it to a file or table for later analysis

"SQL Server Profiler for the following activities"

V Step through analysis of problematic queries and find the cause of the problem

V Find and diagnose slow-running queries

V captures a series of Transact-SQL statements that cause a problem, then replicates the problem on a test server with the saved trace, and then diagnoses the problem on that test server

V supports auditing of operations performed on instances of SQL Server, auditing records of security-related actions for later review by security administrators

V Associating performance counters with diagnostic issues

v Monitor SQL Server performance to worry about workloads