?
Solved

Work Load on Database Tuning Advisor - multiple sql strings

Posted on 2013-11-10
1
Medium Priority
?
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 2000 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

762 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