Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venquet
Starting Member
5 Posts |
 Posted - 2012-08-30 : 06:55:51
|
| Dear All,We are upgrading our products' database from 2005 with 80 mode to 2008 with 100 mode. To verify the query compatibility and performance we captured all queries hitting the SQL-Server-2005 through profiler and tried to re-play the same in SQL-Server-2008 instance. During this replay activity we are facing error called Reply Internal Error with description as Failed to match corresponding value while executing certain type of query which looks PreparedStatement based (which internally uses cursor). Please advise how to fix this error to move forward our upgrade testing. Thanks.RgdsBalaji |
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-30 : 08:30:47
|
| What login do you logged to start trace?Is the database id, database name identical on both server?While you start trace, verify statements that you captured,make sure it is the starting point of transaction.If you capture on the fly transaction, it may be the problem.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulWelcome for all questions. Let us know if our solution solved your problem. |
 |
|
|
venquet
Starting Member
5 Posts |
Posted - 2012-08-30 : 08:53:17
|
| Dear Komkrit,Basically we have same database name and database id in the SQL Server 2008, and there is no any adhock query captured in between we were recorded for one full-day and error happening in the middle of the days query. I couldnt upload the image, let me try to upload somewhere and share you.RgdsBalaji |
|
|
|
venquet
Starting Member
5 Posts |
Posted - 2012-08-30 : 09:08:52
|
Dear Komkrit,Please find the below image  RgdsBalaji |
|
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-30 : 09:17:30
|
| Dear Balaji,Maybe some statements were missing during mid-day.It is possible when your database engine is on heavey load.SQL Server Profiler have and option to set trace on server side.By default, trace is set on client side and no guarantee all event captured.On the dialog box "save to file" , there have a checkbox "Server process trace data", let's try and let us know result.Welcome for your picture, if we have more information, better we could help you.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulWelcome for all questions. Let us know if our solution solved your problem. |
|
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-30 : 09:40:07
|
| Dear Balaji,Thanks for picture. :)Did you capture EventClass "CursorClose" ?Refer to following msdn website. It need sufficient EventClass and column of data to replay the traceReplay Requirements:http://msdn.microsoft.com/en-us/library/ms175525(v=sql.90).aspx- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulWelcome for all questions. Let us know if our solution solved your problem. |
|
|
|
venquet
Starting Member
5 Posts |
Posted - 2012-08-31 : 00:21:52
|
| Thanks Komkrit, let us try this today!RgdsBalaji |
|
|
|
venquet
Starting Member
5 Posts |
Posted - 2012-09-11 : 06:52:28
|
| Dear Komkrit,We have captured all events as mentioned in the SQL forum, still we are getting the above error, after going through in detail we dont have to worry about it since its resultset to client. Now we are geared up for Query capturing in the production environment we tried during non-peakhours and in just 5 minutes profiler captured about 1.6 million events it caused some queries to get suspended with TRACE_WRITE wait status, if we capture at peak hours I am afraid our system may go through performance issue. Please suggest some good approach to capture the query without any performance impact.RgdsBalajiRgdsBalaji |
|
|
|
|
|
|
|
|
SQL Server 2008 Profiler Query Replay Issue