There have been a couple of SQL Server 2008 fixes shipped in recent Cumulative Updates, that address issues you may encounter during ReadTrace processing and .RML generation, or OStress replay. Here are the updates we recommend if you use SQL Server 2008 for your ReadTrace processing, or as the target of your OStress replay:
- ReadTrace or OStress may encounter the following error message when they try to bind a TVP and a subtype as DAE in SQL Server 2008:
“HY010, [Microsoft][SQL Server Native Client 10.0]Function sequence error”
- FIX: An access violation may occur when you run a query that uses a parallel execution plan in SQL Server 2008
In this context these updates are recommended for the SQL Server 2008 machine where you run ReadTrace, and/or for the target of your OStress replay.
Sarah Henwood | Microsoft SQL Server Escalation Services