This content has been marked as final. Show 2 replies
You may want to open a SR with Oracle Suport so we can lend a hand further defining the issue.
Are you able to reproduce this complaint outside SQLServer then? Executing a query via some VBScript for example?
What I'd do to start looking into the issue is get matching client and server sqlnet traces (level 16, with timestamps on) of both the 'fast' and 'slow' environments and compare them. It's hard to relay exactly what I'd look for, but things like a) packet sizes b) are there gaps in the timestamps in the traces where the client is waiting on the database c) is the time between when the packet was sent on the db and received at the client effectively the same d) are all operations a little slower, or are a couple operations responsible for the majority of the difference?
Hope it helps, but realize it probably doesn't.
Thanks for the answer, sorry for the late reply, I was away for Easter.
What we have done is to alter the triggers to record their names, start and end times to an SQL Server table. I delete the contents of the table then run a test and run several queries to analyse the trigger data. the difference between the min start time and the max end time is how we get the total time. We run many queries over the data. I can send you the table DDL and some test run results DML, as well as, the queries I use to analyse the results.
On top of this test we have run Microsoft's NetMon to analyse the network traffic and there it is clear that the packets take roughly twice as long in Win 7 as in Win XP, both in 32-bit and 64-bit OS versions. I know there has been some major network changes after Win XP and Microsoft are convinced this is an Oracle issue. The same OLE Driver is used for both Win 7 and Win XP OS's (excluding the one for 32-bit and one for 64-bit) and my guess is something needs to be tuned for the networking in Win 7. We have really tested this so much over the last 2 months and tried all kinds of network setting tuning in windows but nothing has worked at all.
After creating an SQL DB to act in the place Oracle DB, the same issue was not present, so it really is a heterogeneous platform issue. In fact if the sync is SQL to SQL it is faster in Win 7 not slower.
If you would like any of the results of our testing to see if you can spot the issue, you would be welcome.
Edited by: 925129 on 16-Apr-2012 05:40
Edited by: 925129 on 16-Apr-2012 05:41