Execution Plans

I want to review historical SQL execution plans to determine if SQL has used
parallelism in the past. Is it possible to retreive plans from the proc
cache in a remotely human readable format?
Thanks,
NoelI meant to add that if you want to see how your queries are doing you should
run a trace. There are several events that will let you see things about
parallelism.
Andrew J. Kelly SQL MVP
"Noel Kennedy" <anonymous@.discussions.microsoft.com> wrote in message
news:OJUnIhoPFHA.1396@.TK2MSFTNGP10.phx.gbl...
>I want to review historical SQL execution plans to determine if SQL has
>used parallelism in the past. Is it possible to retreive plans from the
>proc cache in a remotely human readable format?
> Thanks,
> Noel
>|||You wont be able to tell much in that regard from the cached plans.
Parallel execution plans are not cached after use anyway.
Andrew J. Kelly SQL MVP
"Noel Kennedy" <anonymous@.discussions.microsoft.com> wrote in message
news:OJUnIhoPFHA.1396@.TK2MSFTNGP10.phx.gbl...
>I want to review historical SQL execution plans to determine if SQL has
>used parallelism in the past. Is it possible to retreive plans from the
>proc cache in a remotely human readable format?
> Thanks,
> Noel
>