You are a database developer for your company’s SQL Server 2000 online transaction processing database.
You have written several stored procedures that will produce critical sales reports.
The stored procedures access existing tables, which are indexed. Before you put the stored procedures in the production environment, you want to ensure optimal performance of the new stored procedures.
You also want to ensure that daily operations in the database are not adversely affected.
What should you do?