SQL Server Performance Forum – Threads Archive
Checking execution plansHi 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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.