InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:09:59 GMT20http://www.sqlservercentral.com/Forums/Topic1376126-1044-1.aspxThanks all. I did get the article. It looks like a reboot is required after setting the interface so I will have to wait and test during the next approved outage.Thu, 25 Oct 2012 14:39:08 GMTscogebhttp://www.sqlservercentral.com/Forums/Topic1376126-1044-1.aspx[quote][b]scogeb (10/23/2012)[/b][hr]I don't have an account with them and even after I created one, I still can't find it or don't have access.[/quote]Account has to be with Metalink. Oracle's knowledge base and customer support system. If you have Oracle (legally) you have the right to have an account. Once you have your Metalink account just search for the ID Jo has listed.Wed, 24 Oct 2012 18:38:37 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1376126-1044-1.aspxI can't copy or link the oracle support doc as you need an active account.[url=http://odenysenko.wordpress.com/2011/10/28/slow-oracle-net-from-windows-7vista/]Check the blog above, it contains the command below[/url]netsh interface tcp set global autotuninglevel=disabledOther possible culprits: TCP chimney ofloading (see reference Server 2008 Slow Logon Network Access – TCP Offload & TCP Autotuning )Tue, 23 Oct 2012 15:08:43 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1376126-1044-1.aspxThanks Jo, I have 11.2.0 installed. TOT_DATE is actually a number. Do you have a link to that Oracle support file? I don't have an account with them and even after I created one, I still can't find it or don't have access. It looks very relavant though.Tue, 23 Oct 2012 15:00:08 GMTscogebhttp://www.sqlservercentral.com/Forums/Topic1376126-1044-1.aspxWhat version of oracle oledb did you install?[url=http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html]Latest can be found here[/url]Apparently there is a networksetting "TCP window scaling" that might be the culprit:See Oracle support document Oledb and Odbc 64 Bit On Windows 2008 and Windows Vista Have Bad Performances [ID 1264980.1]or [url=http://odenysenko.wordpress.com/2011/10/28/slow-oracle-net-from-windows-7vista/]Intermittent Slow Oracle Net from Windows 7/Vista/2008 machines[/url]Not a solution, but what time takes Select ku_id, TOT_DATE from SIIY where TOT_DATE > 12252012 on the oracle side?Is TOT_DATE a date or a number? If date I would expect where TOT_DATE > to_date('12252012','MMDDYYYY')in openquery you have to double the '*added version of oledb, networksetting TCP Windows ScalingTue, 23 Oct 2012 11:45:34 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1376126-1044-1.aspxAfter upgrading to SQL 2008 R2 on a new 64 bit server, linked queries are running 3 to 4 times as long. On the old 32 bit SQL 2005 system using MSDAORA, the below query takes 7 seconds. On the new 64 bit SQL 2008 R2 system using OraOLEDB.Oracle, it takes 23 seconds.All of the searches I've done and articles I've read so far, suggest that this slow down is normal. Considering I just upgraded everything and everything else on the server is 2 to 3 times faster, this bothers me. Does anyone here have a solution or idea on how to deal with this?SELECT * FROM OPENQUERY(TEST,'Select ku_id, TOT_DATE from SIIY where TOT_DATE > 12252012')Tue, 23 Oct 2012 09:11:34 GMTscogeb