title: How to test performance of the stored procedure in SQL Server Management Studio
body: <p>I want details time taken for the execution of the stored procedure.
  I have tried by cleaning DB cache, but getting difference in seconds resolution only.</p>
  
  <p>Is there any build in method or tool of SQL server to get the detail statistics for the performance of the stored procedure?</p>