SQL Server having OLEDB waits on local view

Question

I have some SQL Server views compiled as follows, some of them brings a large amount of data and causes OLEDB wait type, like if this it's being accessed from another instance.

CREATE VIEW [schema].[view_name] 
AS
    SELECT (...) 
    FROM [instance].[database].[schema].table

Is this a instance's parameter I can set to work without running the VIEW like it was a linked server? We're currently working on SQL Server 2016 and 2019, both return the same results.

Thanks!

Answer 1

I use 4-part names in my views SQL Server will treat it as a linked server?

Yes. And that's a bad thing. So don't do that. Always use 3-part names to refer to objects other databases in the same instance, and 2-part names to refer to objects in the same database.