Tuesday, March 6, 2012

about the workload of DTA?

Why i could not supply a query as workload to tuning engine?

I found some session using query, but mine only have table and file?

many thanks

DTA allows you to 'tune' a single query, or a saved workload (saved in either a file or db table.)

See this article for working details:

http://download.microsoft.com/download/e/8/b/e8b42814-6a0c-40eb-911f-e7adec87f5d5/SQL2005DTA.doc

|||

You have read up on the documentation, correct?

http://msdn2.microsoft.com/en-us/library/ms173494.aspx

No comments:

Post a Comment