• Looks like we're in the same boat.

    I'm also looking into reducing OLEDB waits.

    Here are some links I've found that might help you out.

    http://www.sqlservercentral.com/blogs/sql_server_dba/2011/10/15/sql-wait-type-_1320_-oledb-and-how-to-reduce-it/

    http://www.sqlservercentral.com/blogs/kyle-neier/2008/12/03/oledb-wait-stats-in-sql-server-2005/

    http://www.dbadiaries.com/the-oledb-wait-type-and-how-to-reduce-it

    http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

    I'm pretty sure my OLEDB waits are caused by views using linked servers or other DBs. Looking into ways to better this but can't find any decent info on Views with linked servers and / or other DBs and the alternatives.

    Replication might be my only option.

    Hope the links help you out.



    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort