Could you have a router or other piece of hardware equipment that is giving a priorty boost to some packet types over others?

What version of SQL Server and OS. I know you can, it is just a bit different based off of version and os.

Henry

It didn't show any room for improvement? Did you try going with thurough and setting the number of statements to check up? Also you may want to...

Keep in mind the limits are lower if you are using Unicode data.

SQL 2K does a good job on it's own for the most part. Sometime setting a hard upper limit to allow NT to have some room is a good idea....

Showing my SQL Age

substring(mystring,1,2) + '/' + substring(mystring,3,2) + '/' + substring(mystring,5,2)

Is the OS different between the servers?

Try running the Setup program from the top level of the CD directory.

You could just pipe a sp_lock to a file every N period of time.

My vote would be...

Nope.

You can get a lot of decent stuff for free off the internet anyway.

Have you checked the Oracle server to make sure it is getting the request in the correct format?

Lockwood Techs tool right now is in beta, I don't know how much they will charge when it goes gold. But you can't beat the price right now.

And it...

Do you really need it to be a defined PK, how about just a unique clustered index?

Could you get away with using transaction log shipping?

I suspect you could, however odds are it would fire a rollback. So you would be right back where you started and it would take a while to complete the...