10.2 Database Engine Tuning Advisor (Dta) Tool
Database Engine Tuning advisor (DTA) tool is used analyse / understand .sql queries and .trc (profiler generate trace .trc file) audit reports. This tool gives us recommendations on possible database objects to be created for improving the performance of the queries.
10.2.1 Recommendations - index /statistics /partitions
The recommendations include:
i. index creation / index alter
ii. statistics creation / statistics update
iii. partitions creation / partitions alter
from ssms tool > go to top : tools >> database engine tuning advisor >> specify server name >
input = trace file from profiler tool abvoe. select input database and workload database
start analysis.. this gives "recommendations".
select each recommendation manually >> generate script (last column in recommendation table)
run the script on the database.
or
right click query in ssms >> analyse query in db enine tuning advisor tool. this gives "recommendations" > run scripts
Ref - TechBrothersIT,
No comments:
Post a Comment