how know the performance of query or stored procedure

Posted by Jameschowdare under Sql Server on 1/22/2010 | Views : 2021 | Status : [Member] | Replies : 3

how know the performance of query or stored procedure in sqlserver

Reply | Reply with Attachment

Posted by: Nishithraj on: 1/22/2010 [Member] Bronze

0	You can use the execution plan of SQL Server Query Analyzer Mark this as answer, if it is..... With regards Nishithraj Narayanan Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Pandians on: 1/22/2010 [Member] [MVP] Silver

0	Hi Pls check the link given below... http://www.dotnetfunda.com/forums/thread824-tuning-methodologies-in-sql-server-.aspx Cheers Pandian S Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhi2434 on: 1/22/2010 [Member] [Microsoft_MVP] [MVP] Silver

0	Actual Execution Plan is what you must be looking for. It will show you how many table scans are made and which you need to resolve using Indexes and all other issues. Execution plan also gives you the idea on what is required to optimize the performance. www.abhisheksur.com Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts