Every single SQL Server I manage when I install it I set a max memory that SQL Server can consume to less than what is in the server. That...

First of all if you have a large system and that table is queried a lot you would get a TON of emails.

I don't know if there is a way...

why would you think it acts any different just because it is the master database?

One thing I forgot to mention is the database restore GUI... you click into it and it freezes and hangs for about 30 seconds about 9 out of 10 times.

We are just beginning to see a few SQL2012s here. I noticed that SSMS for 2012 loads slower than 2005, 2008, 2008R2 as well.

The Royals are certainly getting it done now that is for sure.

Can't wait for Opening Day in Cincinnati... hope the rain holds off.

Understood. However, and I have checked and double checked all of the settings and they are all right. If any of those settings were wrong then SQL wouldn't...

At the server teams direction we just changed the SQL Server services to AUTOMATIC (Delay) and restarted the server and it is all good. They are thinking that...

It does. However that cleans up Job history, Maint plan history and restore history if I am not mistaken. It does NOT clean up email history or if you...

Did you, at minimum run Update Stats on the db after you restored it into SQL2014? I make it a habbit of rebuilding the indexes when I upgrade...

When I experienced the issue I was already on the perforamance power plan....

Please post up your SQL Server log where you see the restart. I highly doubt that a COMMVAULT DB backup is causing SQL Server to restart.

You I/Os taking longer...

Other things to do after moving db from SQL2008 to 2012...

run dbcc checkdb with data_purity

also, at bare minimum, run sp_updatestats on the db. It is best to rebuild...

I agree there is a place for each of these in the IT world. As long as one doesn't attempt to use NOSQL or MongoDB in the wrong way...