Solved

Work Load on Database Tuning Advisor - multiple sql strings

Posted on 2013-11-10
1
193 Views
Last Modified: 2013-11-13
When setting a work load for the tuning advisor, can I run multiple sql statements to maximum the different work loads that I have?
0
Comment
Question by:al4629740
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 39639413
Yes, just use a ; and row as delimiter.
OR do double analysis, and see if they interfere with eachother.

Note though:
The DTA should be used as a base for further thinking/examining/designing.
It is not a out of the box solution, use it as pointers where to look, but then educate yourself in execution plans and how clustered/non clustered index works, and what statistics is used for. This will give you better tools to performance/troubleshoot applications.

Regards Marten
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now