I ran the query, (changed the blank db to my db name) and I get nothing 🙁

boggled

No, they are not being restored... just randomly during the course of a normal day the log states, 'Setting database optin SINGLE_USER to ON for database [databasename]

No other message prior...

Thanks All,

I agree that more ram is great..when I said against my wishes I should have stated that I wanted to look at the indexes and queries to find the...