title: Optimizing the SQL query using SQL Profiler
body: <p>I have got below records in SQL Profiler if my proc is called.</p>
  
  <p><strong>CPU - 78, Reads - 3508, Writes - 0, Duration - 81</strong></p>
  
  <p>Is above data is ok for concurrent hits for 70 person on my website, My proc is called on evey page the user is visiting, the performance monitor on my server shows anonmyous user hit keep increasing when I enable my SQL proc calling.</p>
  
  <p>Please suggest what and where I can look!!, my proc query is given below:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[GETDataFromLinkInfo] 
  -- Add the parameters for the stored procedure here 
  (@PageID INT) 
  AS 
    BEGIN 
        -- SET NOCOUNT ON added to prevent extra result sets from 
        -- interfering with SELECT statements. 
        SET NOCOUNT ON; 
  
        -- Insert statements for procedure here 
        SELECT DISTINCT [PUBLICATION_ID] AS n, 
                        [URL]            AS u 
        FROM   [LINK_INFO] WITH(NOLOCK) 
        WHERE  Page_ID = @PageID 
               AND Component_Template_Priority &gt; 0 
               AND PUBLICATION_ID NOT IN( 232, 481 ) 
        ORDER  BY URL 
        FOR XML RAW ('p'), ROOT ('ps'); 
  
        RETURN 
    END 
  </code></pre>