We have two SQL servers and they are configured as linked servers. There is one specific stored procedure when, at startup, you need to attach tables from the linked server to it. Often this seems like forever, and looking a little, it seems that in the activity monitor it gets "PREEMPTIVE_OLEDBOPS". But this only happens when SP is called from ASP.NET. When I run a query in SQL Server Management Studio, the query starts after 6 seconds - every time.
I am not dBA, so my knowledge here is quite superficial. Googling for this error code offers a wait code, but I could not get any information on how to avoid them or what exactly causes it.
Thanks for any help, ~ P
source
share