I did find an sp_updatestats command that runs every night - but it is pointed to a single database (thought I had found the issue for a second). After tonight...

Yes, stopped the Index maintenance job for 2 days with no change in results.

It is a single instance on the VM box, but I have 180 small databases with 2 TB total datafiles. Only 5 or 6 databases should be very busy (my...

• This reply was modified 3 years, 6 months ago by  stevec883.
• This reply was modified 3 years, 6 months ago by  stevec883.
• This reply was modified 3 years, 6 months ago by  stevec883.

That's an interesting point. Sp_BlitzCache told me a top priority was plans being built daily, but our server is not really taxed. I will check the indexes as well. Do...

• This reply was modified 3 years, 6 months ago by  stevec883.

Thanks Jeff -- I appreciate your insight. I am re-evaluating a lot of things the former DBA setup, and I have heard this from more than one good source that...

@fred Thanks, I will look into the details of the indexes that need it, I guess this would be due to excessive inserts that would cause daily fragmentation...

Thanks Jeff and Sergiy - I was thinking that as well, that this is beyond repair and no amount of indexing or other tuning can fix it. Thanks for clarifying....

Thanks Fred - Yes, I think this one is almost too convoluted to repair, need to start over with a new query.

Frederico - that is the Actual Execution Plan (captured after the query ran).

Thanks, I pasted the plan;

https://www.brentozar.com/pastetheplan/?id=B1Jo9m4WY

The execution plan is huge. Should I paste it as XML? I can't do a screen shot because it goes way off the screen in both directions.

Thanks Brian. The server is set to optimize for ad hoc queries. Developers writing their own queries seems to be on ongoing reality. Is there any other way to keep...

• This reply was modified 3 years, 7 months ago by  stevec883.

I

• This reply was modified 3 years, 7 months ago by  stevec883.

Thanks -- I was thinking that too. I have it going to a temp table now (to scrub the data) but will look into adding a section for the Inserts/Updates.

Thanks again for the great points. I will be able to test the snapshot and I believe the SAN disk being on a different SAN device could be a problem...