Comparison of performance of ex stored procedure and new version

Question

I created two new indexes in the tables that are used in sp. New results show that from the side of problematic associations, scanning is converted to search. I think search is better than crawl. On the other hand, time takes more or less the same duration as without the new indexes.

It is as clear as I can satisfy before putting my new version of sp into production.

For example, changing sp parameters can help me find out if the new version will be faster than the old version or what else?

Relations B.K.

Answer 1

, :
1) , , . , ( ):

CHECKPOINT -- force dirty pages in the buffer to be written to disk
DBCC DROPCLEANBUFFERS -- clear the data cache
DBCC FREEPROCCACHE -- clear the execution plan cache

2) SQL Profiler Reads/Writes/CPU/Duration ( / ). (.. , SSMS).
Edit: SQL Profiler, Management Studio → SQL Server. db . " " - "", . , SQL Profiler - ​​ , .. .

3) , . , .

, , , .