Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Performance evaluation tool...

Author  Topic 

anandc
Starting Member

20 Posts

Posted - 2006-01-02 : 06:47:35
Hi

I have 2 different procedures for same functionality, I want to measure the performance of both the procedure. Is there any tool available which will let me know which of the procedure is better of the two without having to do much of research.

Thanks

- Anand

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-02 : 06:53:25
When running them in the Query Analyset Set the Execution Plan and check
Press Ctrl+K and run them

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -