Checking execution plans | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Checking execution plans

Hi folks!<br /><br /><br />Does anyone knows if it’s possible to review the execution plan for a running query without generating an Estimated Execution Plan thru Query Analyzer or tracing it thru Profiler?<br /><br />Is the syscachedobjects systable useful for this? [<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />]<br /><br /><br />I saw something like this on Oracle, but nothing on SQL Server.<br /><br /><br />Thanks!
As far I know, no.
Just curiosity, why do you need that? I mean outside of SQL tools. Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Hello Luis! Thanks for your reply!<br /><br />It’s not really a need, just curiosity also! <img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ /><br /><br /><br />Regards,<br /><br />Fernando Toledo fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.