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=’
‘ />]<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
SQL-Server-Performance.com 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
http://www.sqlservercentral.com/columnists/RDyess/obtainingqueryexecutionplansthroughsqlprofilertrac.asp fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>