1. Computing

Discuss in my forum

Mike Chapple

DETA in SQL Server 2012

By November 1, 2012

Follow me on:

DETASQL Server 2012's Database Engine Tuning Advisor (DETA) provides database administrators with a powerful way to tune your database for your specific environment. DETA allows you to design a customized workload that mimics your operational environment and then analyze that workload to determine the optimal configuration settings for your SQL Server instance. DETA's recommendations include adding normal and clustered indexes to your database, partitioning tables and creating indexed views, where appropriate.

Read the full article: DETA in SQL Server 2012
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
  1. About.com
  2. Computing
  3. Databases

©2014 About.com. All rights reserved.