Scribd
Upload
77 views2 pages

Performance Tuning - Index Management & DTA

This document discusses various topics around performance tuning databases in SQL Server including index management, the Database Tuning Advisor, statistics, index rebuilding and reorganization, compression options, and SQL Server maintenance plans. It also covers troubleshooting memory, log file, and tempdb issues and database monitoring techniques. Database migrations, service packs, and server upgrades are addressed as well.

Uploaded by

NamJK
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
77 views2 pages

Performance Tuning - Index Management & DTA

This document discusses various topics around performance tuning databases in SQL Server including index management, the Database Tuning Advisor, statistics, index rebuilding and reorganization, compression options, and SQL Server maintenance plans. It also covers troubleshooting memory, log file, and tempdb issues and database monitoring techniques. Database migrations, service packs, and server upgrades are addressed as well.

Uploaded by

NamJK
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Performance Tuning - Index Management & DTA

Index Internals and Execution Plans

Index Fragmentation - Issues & Solutions

SAMPLED & DETAILED Query Scans

Database Tuning Advisor (DTA) - Usage

Understanding PDS Options with Indexes

Choosing Correct Option (PDS) for Tuning

Filtered Indexes and Sizing Options

Analyzing Work Load Tables and Scans

Understanding Statistics in Query Tuning

Statistics Role in Query Tuning Process

Index Management Options & Statistics

Statistics - AUTO CREATE, AUTO UPDATE

Stats Updates (Manual) and Issues

Index Rebuilds & Tuning Options

Table Rebuild Options with Indexes

Index Reorganization Process and Uses

Page, Row Compressions with Indexes

FILLFACTOR, PADINDEX Index Options

Filtered Indexes, Online Indexes, Views

Understanding Workload Files in Profiler

SQL Profiler Workload Tables & Queries

SQL Profiler Tuning and Lock Templates

Index Selectivity Options and Statistics


Management - SSIS Database Maintenance Plans

Database Maintenance Plans (SSIS)

DB Maintenance Strategies & Schedules

MSDB History Management Options

Backup Files and Space Management

Reorganizing Indexes with Maint. Plans

Stats Updates (Automatic) and Jobs

Modifying SSIS DB Maintenance Plans

Scheduling and Maintaining SSIS Plans

Log File Issues and Shrinking Operations

SQL DB Engine Properties & Guidelines

Service Configuration Manager Options

Distributed Transactions & Connections

Query Governor Usage and DOP Options

Policy Based Management (PBM), Facets

Database Properties and Conditions

Scheduling Policies & Event Management

Considerations for Policy Management


Alerts and Troubleshooting Issues

LOG File Space Issues and Solutions

TEMPDB Space Issues with Solutions

MEMORY Management Issues - Solutions

OS Level Memory Clerks and Montoring

Memory Leaks, Hits and Solutions

Logical and Physical Memory Architecture

Memory Buckets, IO Entires


Procedure Cache Issues and Solutions

Procedure Cache Size & SQL Buffer Size

DB State Events, Issues and Solutions

Network Usage, Monitoring, Optimization

Performance Monitor (PERFMON) Counters

Replication Threshold Values & Agents

Database Options and Downtime

Database States Alerts and DB Events

DBCC Commands and Database Repairs

Rebuild Operations and Considerations

Important DMVs and DMFs for Audits


DB Migrations, Service Packs & Server Upgrades

Establishing Downtime For Maintenance

Precautions for Maintenance Activites

Detach - Attach Procedures (SSIS)

Copy Database Wizard - DB Copy/Move

SMO Connections and Offline Options

Service Packs and Patch/hotfix Activit

You might also like