Work Load on Database Tuning Advisor - multiple sql strings

When setting a work load for the tuning advisor, can I run multiple sql statements to maximum the different work loads that I have?
al4629740Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.