Post reply

DTA - How to delete the session?

  • March 15, 2012 at 6:48 am

    #270107

    Hi,

    Database Tuning Adviser - performance Tool.

    Interrupt and stop analysis during perform analysis report, Not yet completed for analysis report.

    After that I am not able to delete the session, still showing in DTA. now session option are visible as below

    New session

    Open session

    close session

    Rename session

    clone session

    But Delete option is disable, not able to delete that session, please tell me how to delete that session.

    thanks

    ananda

  • March 17, 2012 at 4:37 am

    #1460851

    use the stored proc dbo.sp_DTA_help_session to get session details then use dbo.sp_DTA_delete_session to remove it. These procedures are in the MSDB database 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 17, 2012 at 4:47 am

    #1460853

    Hi,

    Mr.Perry Whittle, this is excellent reply..

    I have successfully deleted that DTA session with help of using

    sp_DTA_delete_session 2 ( 2 is session id)

    Thanks

    ananda

Viewing 3 posts - 1 through 2 (of 2 total)

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