Comparing Two SP's Performance SQL Server

Question

there is any simple way to know which one of two SQL Store procedure works better?

If you are wanting to compare performance then compare the actual Execution Plan s for both stored procs. — Igor, Jun 14 '17 at 20:55
https://stackoverflow.com/questions/7649109/what-tools-are-out-there-for-profiling-stored-procedures-in-sql-server-other-tha — mrogers, Jun 14 '17 at 20:56

score 2 · Accepted Answer · answered Jun 14 '17 at 21:01

2

Click the Include Actual Execution Plan before running both sp (on the same run) and check the percentages

answered Jun 14 '17 at 21:01

rmed1na

1 Answers1