Capturing, Measuring, and Replaying a Workload Using SQL Profiler - Professional SQL Server 2005 Performance Tuning - page 351

Figure 10-29
Number of RPC and SQL Batch Completed
Per Minute in the Workload
30000
25000
20000
15000
10000
5000
0
Figure 10-30
To summarize results in this scenario, the target server TestServerH received five workloads from dif-
ferent Profiler replay sessions. All database user transactions were completed within milliseconds. Disk
I/O and memory are within their thresholds. Even though CPU consumptions are on the high side, the
target server TestServerH handled workloads well. With well-defined workload definitions and a tar-
get server preparation, SQL Profiler replay can be used to analyze an overall performance for workload
consolidations.