Post reply

DTA Stop in between will DTa not release the control

  • July 28, 2017 at 1:38 pm

    #338546

    Hi,

    If the DTA is stopped is between while running on a database (all tables) on Plan Cache, can that create a Deadlock?  Sometime back I found similar situation where I found one connection through that the DTA ran spawned huge threads. Is this because of DTA was stopped in between and it was broken to release connection?

    Thanks.

  • July 28, 2017 at 1:40 pm

    #1953247

    Note: there was no impact on CPU/memory on the server. CPU was tingling below 30%

    Thanks.

  • July 28, 2017 at 1:43 pm

    #1953248

    The DTA is not kindly looked upon in these forums. It tends to produce quirky recommendations.

    There are far better ways of tuning indexes, if you are interested in learning.

    I've never heard of CPUs 'tingling' before!

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 28, 2017 at 1:47 pm

    #1953250

    Microsoft Support Engineer suggested to run DTA to get a feeling about the indexes.

    Thanks.

  • July 28, 2017 at 2:25 pm

    #1953255

    SQL-DBA-01 - Friday, July 28, 2017 1:47 PM

    Microsoft Support Engineer suggested to run DTA to get a feeling about the indexes.

    And just what do you mean "a feeling about the indexes?"

  • July 28, 2017 at 4:19 pm

    #1953259

    Don't ever run DTA against your production DB. If you do want to use it, run it on a test server and evaluate its recommendations carefully before implementing any.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply