Jeff, just an update regarding this post. What I learned is that trivial plans appear to update stats automatically when enough modifications are made, but only if the query isn't...

Well, not sure. I think I just deleted all of the .xel files in the folder and retried. Seemed to work finely after that.

thanks all. Seems to be working now.

Yes

To clarify, I have sysadmin rights on the server (my home computer). I tried the following steps.

1. create a test database
2. right click package0.event_file, select view target data
3. no events...

hi Jeff, I think the problem was that I didn't restart the server after messing with the auto update stats and auto update stats async values. Without restarting the server,...

hi Grant,

thanks for the info. I'm brand new in SQL Server, so I appreciate your answers to my questions. I read an article on extended events. However, would you be...

Got it. Thanks for the info. New to SS!

Frederico, I read this document a few days ago. It doesn't get into what to set the cache size to. But, after I posted, I realized as Scott said that...

Thanks Scott. After I posted my question, I was thinking along the lines that you wrote.