Viewing 15 posts - 1 through 15 (of 194 total)
Yes, that's exactly it - thank you!
'Only he who wanders finds new paths'
July 19, 2017 at 11:50 pm
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...
'Only he who wanders finds new paths'
February 9, 2016 at 8:32 am
Aah, it would be! Thank you.
'Only he who wanders finds new paths'
January 12, 2016 at 6:56 am
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...
'Only he who wanders finds new paths'
December 31, 2015 at 6:20 am
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...
'Only he who wanders finds new paths'
December 31, 2015 at 6:15 am
Idera have a tool called Compliance Manager, might be worth checking out.
'Only he who wanders finds new paths'
December 15, 2015 at 5:16 am
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...
'Only he who wanders finds new paths'
December 9, 2015 at 12:02 pm
Grant Fritchey (12/7/2015)
Take a look at the book "Troubleshooting for the Accidental DBA" That will give you plenty of knowledge to do this. Plus, it's free to download.
Huge thumbs up...
'Only he who wanders finds new paths'
December 9, 2015 at 11:56 am
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...
'Only he who wanders finds new paths'
November 17, 2015 at 7:33 am
GilaMonster (11/11/2015)
david.alcock (11/11/2015)
Hekaton does have a rather impressive list of limitations to its usage, those need checking prior to implementing.
Yes, but to be clear, most of those limitations are for...
'Only he who wanders finds new paths'
November 11, 2015 at 2:26 am
Hekaton does have a rather impressive list of limitations to its usage, those need checking prior to implementing.
'Only he who wanders finds new paths'
November 11, 2015 at 1:54 am
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...
'Only he who wanders finds new paths'
November 10, 2015 at 4:57 am
Facepalm, I bet its because the mail hasnt been enabled on SQLAgent, aaaargh!
'Only he who wanders finds new paths'
February 18, 2015 at 8:38 am
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...
'Only he who wanders finds new paths'
February 10, 2015 at 12:02 pm
Excellent, and yes there is a wealth of information and knowledge on here!
'Only he who wanders finds new paths'
January 21, 2015 at 3:16 am
Viewing 15 posts - 1 through 15 (of 194 total)