database-tuning-advisor Archives

MS SQL 2008 Express – Database Tuning Advisor

By adminPosted on August 7, 2023

Question : I want to use DTA, but on my website I have an Express Server version. Can I backup […]

By adminPosted on July 19, 2023

Question : Hi I’ve generated a trace file using SQL Server Profiler and save that trace as a table in […]

By adminPosted on June 30, 2023

Question : In the past I thought I’d deleted hypothetical indexes using either a DROP INDEX statement for clustered indexes […]

By adminPosted on March 7, 2023

Question : Hi I’ve generated a trace file using SQL Server Profiler and save that trace as a table in […]

By adminPosted on May 29, 2022

Question : My Windows workstation can launch the GUI for the Database Engine Tuning Advisor, but the CLI called “dta” […]

By adminPosted on March 20, 2022

Question : I was asked to create an account to use Database Tuning Advisor. I red on technet but I […]

By adminPosted on March 3, 2022

Question : How should I rely on SQL Server 2012 Database Engine Tuning Advisor for creating indexes and statistics? I […]

By adminPosted on May 10, 2021

Question : Several years ago I ran Database Tuning Advisor on our database. Then the database wasn’t very big so […]