Yes, that's exactly it - thank you!

Absolutely not a setting to be made at the instance level. Routinely check the fragmentation levels, look for any repeat offending indexes that have high fragmentation and then gradually reduce...

Aah, it would be! Thank you.

Just bear in mind that if for whatever reason your databases are using the older compatibility level then the changes to the CE will not take effect.

Here are some testing...

I think (and I am hunting around the back of my mind here) there are two accounts, the discovery agent and the monitoring. Not sure about the discovery account but...

Idera have a tool called Compliance Manager, might be worth checking out.

If you can be on the server when PLE drops significantly a script like sp_whoisactive would show the likely suspects...if its within SQL. Had a similar thing and it turned...

Huge thumbs up...

I think "it depends" on what type of DBA you want to be.

Sure, learning code is up there, but if you're a pure production DBA it might not be...

GilaMonster (11/11/2015)

Yes, but to be clear, most of those limitations are for...

Hekaton does have a rather impressive list of limitations to its usage, those need checking prior to implementing.

I tend to create a recovery folder for each server I manage. In there put in things like screen shots of the volumes, services and also up to date...

Facepalm, I bet its because the mail hasnt been enabled on SQLAgent, aaaargh!

So the fix appears to be simply install SP2 again.

I guess this is because a security hot fix was installed that supersedes SP2 in date, it has rolled...

Excellent, and yes there is a wealth of information and knowledge on here!