• I've found the DTA will fail around 50% of the time I use it. I've never given it much thought and my general view is that you can extract the same info from the dmvs as you can from the DTA , stop your server to clear the dmvs, run your query and then see what missing indexes are suggested by the dmvs

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/