Capture the Workload
Use the SQL Server Profiler to capture a workload that will be applied by Distributed Replay. Use the Profiler template named TSQL_Replay. This template captures the columns and events that are needed to replay a workload. If you exclude any of them, you will not be able to preprocess your trace file. Also, it is highly recommended that you capture your workload using a server side trace rather than the Profiler GUI. Refer to Chapter 5 “SQL Server Profiler” for a more detailed discussion of SQL Server Profiler and how to capture a trace file.
Once you have started the Profiler Trace you are ready to apply a workload against the SQL Server instance. For demonstration purposes, the following statements were executed against ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
