Hi, I am new to performance tuning of stored procedures. I got to improve the performance
of a particular stored procedure which is making application to load the page slowly.
The front end application is .net and DB is SQL Server 2008.
Can any one please let me know how do I debug the stored proc to see which part of the stored proc
is taking too much time ? do i need to use any execution plans ?