Cheetah (10/30/2013)
The query to extract the plan cache fails when there is an offline database on the server.
I have two databases that are offline on my instance currently and the query succeeds. I don't think the issue is related explicitly to an offline database. Maybe you have queries returning in your results for the offline database based on the filter you are using. Maybe you have some queries that join to these offline databases that are returned in your result set based on the filter you are using.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events