Post reply

Profiler/ITW QUestion

  • April 27, 2005 at 5:22 am

    #165289

    Hi Guys,

    I am starting some monitoring/performance tuning on our production database.

    The database is on a clustered server.

    I would like to run the Index tuning Wizard.

    I have run a few traces on the clustered server and captured plenty of data and stored it in a database table(s).

    I have a test server on which I would like to run the tuning...all sounds straightforward so far.

    We have a staging database which is a complete replica of our live production database.

    Can I use a copy of this database to run the ITW with the trace file or do I need to get a copy of the live database.

    Plus does anyone else have any experience in using the ITW...anything I should look out for?

    Many Thanks

    Graeme

  • April 27, 2005 at 12:35 pm

    #555361

    I don't use the ITW much, but I have used it in the manner you describe.  I don't recall any problems at all.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • April 28, 2005 at 12:55 am

    #555436

    Hmmm.....must be me then!

    I have found that if there are UDFs in the sql statement or procedure, then the ITW complains....would this be correct.

    I guess I'm gonna have to go back to basics with the index tuning...

    Thanks..Graeme

  • April 28, 2005 at 2:09 am

    #555451

    In any case I would not let ITW make any modifications to the database directly. Script the actions ITW suggests and decide yourself whether or not to implement them.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • April 28, 2005 at 2:13 am

    #555453

    Absolutely Chris.

    I was just interested in any results it might give.

    Thanks again

    Graeme

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

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