compdigit44
asked on
Sharepoint 2010 DB Stats
In Sharepoint 2010 I have read that Sharepoint has a timer job to automatically update stats on all Sharepoint DB's. Is this true. If so, how can I check to make sure it is running correctly?
Should I create a separate SQL update stats maintenance plan?
Should I create a separate SQL update stats maintenance plan?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow, this is an amazing article!!!
I noticed they recommend running an update stats SQL job. If I schedule a maintenance plan to update stats daily is this the same thing..
I am not the best at SQL but try my hardest to learn....
I noticed they recommend running an update stats SQL job. If I schedule a maintenance plan to update stats daily is this the same thing..
I am not the best at SQL but try my hardest to learn....
Yes that is the same thing
ASKER
Should I run an update stats job daily????
It also discusses some things that may/not happen and how to do some detective work.
But in a nutshell, yes it is true, you can check success/fail of timer jobs in central admin under monitoring.