Hello Orange - yes I did. There were tons of queries that were not parameterized. Developers for years had structured their apps to pass literals into the queries rather than...

SS Crazy: I am testing the script; it actually shows my ID and the script (which would makes sense), but I am connected via SSMS with a TestUser account and...

Thanks Grant, I'll try that as well.

Thanks SSCrazy Eights - this is exactly what I needed. I will also give profiler a shot as well.

Table stats is the first thing that came to mind as well. It's kind of amazing that there is no feature in SSMS to get more details of which logons...

• This reply was modified 3 years, 1 month ago by  stevec883.

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, 2 months ago by  stevec883.
• This reply was modified 3 years, 2 months ago by  stevec883.
• This reply was modified 3 years, 2 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, 2 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