Sharepoint 2010 DB Stats

compdigit44
compdigit44 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
QPR

Commented:
Here is a great article that explains the timer job involved, the default schedule time (so you can check success) and some t-sql that allows you to view the stats and when last updated.
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.

Author

Commented:
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....
QPR

Commented:
Yes that is the same thing

Author

Commented:
Should I run an update stats job daily????

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial