The following mandatory events required for replaying trace were not found: RPC:Starting SQL:BatchStarting please add the required information and recreate the trace table with sql profiler.
Could not register cfx32.ocx (hr = 80040200
Could not register BFDurationCtrl.ocx (hr = 80040200
Attempted even with all events/columns checked and it never works.
steps:
1.run sqlprofiler trace with tuning template or standard template, create to table within database
2.stop trace
3.verify table exists and contains data from trace
4.open benchmark factory
5.specify to do a standard benchmark test by running a load from a sql server profiler trace table
6.connect to sql server instance and navigate to trace table
7.mandatory error as stated above
Steps you canfollow to create a trace table
1. run sqlprofiler trace with standard template, create to table within database(use sa login)
2. do some operations. such as select.
3. stop trace.
4. verify table exists and contains data from trace. make sure the tables owner is dbo.
5. open benchmark factory
6. specify to do a standard benchmark test by running a load from a sql server profiler trace table.
7. connect to sql server instance with sa and navigate to trace table.
Use the owner of the trace table to login database. For example select count(*) from ss_dba_dashboard.dba_dashboard.thomastest_qs2 where TextData IS NOT NULL, use dba_dashboard login to the database.
You need use the owner of the trace table to login database. Otherwise even if you use sa the error still appear.
