high OLEDB wait and slow perfromance for query using linked server
hello all, i experincing slow perfromance query execute linked server , on remote server .. envireoment sql server 2008 x64 clusterd on windows server 2008 ia i have selected wites types , here result pls help http://blog.sqlauthority.com/2011/02/23/sql-server-oledb-link-server-wait-type-day-23-of-28/ best regards, uri dimant sql server mvp http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server > SQL Server Database Engine