Solved

Work Load on Database Tuning Advisor - multiple sql strings

Posted on 2013-11-10
1
192 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

744 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

10 Experts available now in Live!

Get 1:1 Help Now