509 lines (509 loc) · 29.5 KB

layout

HubPage

hide_bc

true

experimental

true

experiment_id

81ba5f65-59fb-4d

title

Manage, Monitor, Tune SQL Server

description

Discover the features that help you manage, monitor, and tune your SQL Server.

ms.topic

hub-page

ms.prod

sql

author

MashaMSFT

ms.author

mathoma

manager

craigg

ms.date

12/15/2018

featureFlags

clicktale

SQL Server: Manage, Monitor, and Tune

- - Manage
  - Database life cycle management
    
    A comprehensive approach to managing the database schema, data, and metadata for a database application
  - Data compression
    
    A feature of SQL Server that facilitates the compression of your data so that it takes less space on disks.
  - Database mail
    
    An enterprise solution for sending e-mail messages from the SQL Server database engine.
  - Policy-based management
    
    A policy-based system for managing one or more instances of SQL Server.
  - Maintenance plans
    
    Configure automated plans to manage your SQL Server.
  - SQL Server Agent
    
    A feature of SQL Server that executed scheduled administrative tasks.
  - Transaction log management
    
    A concept that helps facilitate the recovery of data in the event of a disaster.
  - Monitor
  - Extended Events
    
    A general event-handling system for SQL Server systems.
  - SQLDiag
    
    A general purpose utility that collects logs and data from SQL Server.
  - SQL Profiler
    
    Create, manage, analyze and replaces traces taken of SQL Server activity.
  - Tune
  - Automatic tuning
    
    A new feature of SQL 2017 that automatically detects potential performance issues.
  - Database Tuning Advisor
    
    Helps analyze workloads and provides performance improvement recommendations.
  - Cardinality Estimation
    
    Estimates how many rows will be returned by a query, and used for execution plan creation.
  - Indexes
    
    An on-disk structure associated with a table or view that speeds retrieval of data.
  - In-Memory OLTP
    
    A performance optimization option that leaves entire tables in memory.
  - Partitions
    
    Allows for data to be spread across units, such as file groups.
  - Plan guides
    
    A feature of SQL Server that allows for the manual input of an execution plan for a specific query.
  - Resource governor
    
    Specifies limits on the amounts of CPU, IO, and memory that application requests can use.
  - Statistics
    
    Tells the SQL Server engine how data is distributed, and used for the creation of execution plans.

Keep in touch with us