Post reply

Error running Index Tuning Wizard

  • February 13, 2002 at 9:59 am

    #104873

    Anyone know the following error...

    Error Analyzing workload (60)

    Thanks

    Scott

    Edited by - scottsanpedro on 02/13/2002 09:59:53 AM

  • February 13, 2002 at 11:24 am

    #423776

    Haven't seen it. Any more info?

    Steve Jones

    steve@dkranch.net

  • February 13, 2002 at 12:23 pm

    #423778

    i was following some MS documentation to demonstrate how to use profiler and index wizard. I have actually come across this error a few times now.

    I have checked all of MDSN to no avail.

    There's not alot more i can say, I will re run this procedure tomorrow and inform what exactly i'm doing.

    I'm using Windows 2000 with SQL 7.0

    Thanks

  • February 13, 2002 at 12:33 pm

    #423783

    Haven't had an issue and I've run the tuning wizard a few times. It can be slow and uses some resources. Is it possible you are running out of resources? Does the wizard run at all? When does it error out? what service pakc on SQL?

    Steve Jones

    steve@dkranch.net

  • February 14, 2002 at 2:24 am

    #423816

    ok..I am running (Build 1381: Service Pack 6)

    I run profiler from start menu. Click on tools, Index tuning wizard..etc etc. Select the workload file I created earlier. Select the table I want checking then click next and get the above error.

    I did try it again with a table that has nothing to do with the trace and it got a step further but then seemed to freeze.

    Doesn't seem like a general error so maybe a re-install of some of my software.

    Cheers

    Scott

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

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