how know the performance of query or stored procedure

Posted by Jameschowdare under Sql Server on 1/22/2010 | Views : 1032 | Status : [Member] | Replies : 3
how know the performance of query or stored procedure in sqlserver




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response