Questions tagged [database-tuning-advisor]
For questions about the SQL Server Database Engine Tuning Advisor - a Microsoft tool that recommends changes to database structures to improve query processing performance.
16
questions
1
vote
0
answers
576
views
Tuning process exited unexpectedly. (DTAEngine)
I know there is the same question, but I'm running it on a different version and still have the issue.
I was running the DTA from the GUI - workload source was Query Store and I ran the analysis ...
- 3,931
0
votes
1
answer
203
views
Database Tuning Advisor CLI "dta" missing
My Windows workstation can launch the GUI for the Database Engine Tuning Advisor, but the CLI called "dta" is missing. Why?
Background
The Database Tuning Advisor is a SQL Server tool for ...
- 219
0
votes
0
answers
132
views
SQL Server inconsistently reporting missing indexes
I have a stored procedure that is not performing well and I am trying to tune it. I am confused by what I see in SSMS and the Database Tuning Engine Advisor.
In SSMS I have 'Include Actual ...
- 101
2
votes
1
answer
67
views
Should SQL Server statistics be included in versioning?
Recently I ran the SQL Server Tuning Advisor. It suggested to add some statistics. Currently we have no statistics checked in our database versioning.
My question is: Should these suggested ...
- 17
0
votes
2
answers
67
views
Change of index key columns order affects performance
I have the following table in my database:
create table [dbo].[tb_StatusLog](
[RequestID] [int] not null,
[statusID] [int] not null,
[startTime] [datetime] not null,
[endTime] [datetime] null,
)
...
- 161
1
vote
2
answers
393
views
Views created by SQL server Database Tuning advisor
Several years ago I ran Database Tuning Advisor on our database. Then the database wasn't very big so it was easy.
I implemented the suggestions, and it created several views with names like ...
- 113
5
votes
2
answers
2k
views
Can I use Database Engine Tuning Advisor for Azure?
I am trying to use "Database Engine Tuning Advisor" for queries in Azure SQL.
According to https://learn.microsoft.com/en-us/sql/relational-databases/performance/start-and-use-the-database-engine-...
3
votes
1
answer
9k
views
Database Tuning Advisor error: ...% of consumed workload has syntax errors
Hi I've generated a trace file using SQL Server Profiler and save that trace as a table in SQL server DB. The trace file workload was generated by executing a query directly from SQL Serve Management ...
- 179
1
vote
1
answer
3k
views
Database Tuning Advisor user permissions
I was asked to create an account to use Database Tuning Advisor.
I red on technet but I don't understand which permission do I have to give.
I tried to login with this new user, but trying to list ...
- 13
2
votes
1
answer
100
views
Why would an index covering only half of primary key be useful?
We have a primitive junction table to store a many-to-many relation between two other tables, their primary keys being bigint:
CREATE TABLE [dbo].[JunctionTable] (
[ID-1] [bigint] NOT NULL,
[...
- 123
1
vote
1
answer
340
views
Database Tuning Advisor Index Recommendations
How does DTA make an index recommendation? What is the technology behind that? If we can use same on our side then we can shorten the whole process of Tuning recommendation:
creating trace file using ...
- 401
5
votes
2
answers
6k
views
Can I trust the Database Engine Tuning Advisor recommendations?
Our database has become large, and we are trying to optimize performance.
Can we follow the recommendations provided by the Database Engine Tuning Advisor by supplying it a .trc file generated with ...
- 51
8
votes
3
answers
6k
views
Dropping Hypothetical Indexes
In the past I thought I'd deleted hypothetical indexes using either a DROP INDEX statement for clustered indexes and DROP STATISTICS statement for non-clustered indexes.
I have a database that is ...
- 828
6
votes
2
answers
2k
views
Should I rely on Database Engine Tuning Advisor for creating indexes?
How should I rely on SQL Server 2012 Database Engine Tuning Advisor for creating indexes and statistics? I find more often than not, it generates overly complex indexes that (I think) would be more ...
- 1,477
2
votes
1
answer
1k
views
MS SQL 2008 Express - Database Tuning Advisor
I want to use DTA, but on my website I have an Express Server version.
Can I backup my DB on Express server, restore it on my personal computer with Enterprise Version, make some tuning by DTA and ...
udar_molota
5
votes
3
answers
559
views
Using DTA vs. evaluating DMVs?
Currently I am confronted with a production SQL Server database where someone had added almost all missing index proposals from DTA.
Form How to determine if an Index is required or necessary I have ...
- 12.2k