SQL Server Performance Forum – Threads Archive
SQL Profiler Procedure-Subqueries
Hi, Is there any possibility to measure start/endtime of a subquery in the procedure like in the following example. I can see start/endtime, if a function or procedure is called but I didn’t get along with subqueries. PROCEDURE SELECT A.*, B.* FROM(SELECT * FROM X) A INNER JOIN
(SELECT * FROM) B ON A.ID = B.ID Thanks in advance.
As for stored procedures – out of the stored procedure events – the objectname is NOT produced for SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtStarting or SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtCompleted but the ObjectID is. So – there are often cases where you might see a value for objectname and not for objected or visa versa. For more details check out the following topics in the BOL. <br /><br />Check out this topic in the SQL Server Books Online: Stored Procedures Event Category <br /><br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
Hi Satya,<br /><br />Thanks for your reply. When I trace SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtStarting or SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtCompleted, then I see a lot of times that the procedure is called. But in the text I see the entire text of the procedure and I can’t see which part of the procedure is called. So I can’t analyse which subquery takes mostly the time. This is my problem at the moment.
Add the column for ObjectID & OBject name to see more. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>