Question : I want to use DTA, but on my website I have an Express Server version. Can I backup […]
Tag: database-tuning-advisor
Database Tuning Advisor error: …% of consumed workload has syntax errors
Question : Hi I’ve generated a trace file using SQL Server Profiler and save that trace as a table in […]
Dropping Hypothetical Indexes
Question : In the past I thought I’d deleted hypothetical indexes using either a DROP INDEX statement for clustered indexes […]
Database Tuning Advisor error: …% of consumed workload has syntax errors
Question : Hi I’ve generated a trace file using SQL Server Profiler and save that trace as a table in […]
Database Tuning Advisor CLI “dta” missing
Question : My Windows workstation can launch the GUI for the Database Engine Tuning Advisor, but the CLI called “dta” […]
Database Tuning Advisor user permissions
Question : I was asked to create an account to use Database Tuning Advisor. I red on technet but I […]
Should I rely on Database Engine Tuning Advisor for creating indexes?
Question : How should I rely on SQL Server 2012 Database Engine Tuning Advisor for creating indexes and statistics? I […]
Views created by SQL server Database Tuning advisor
Question : Several years ago I ran Database Tuning Advisor on our database. Then the database wasn’t very big so […]