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?
LVL 21
compdigit44Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QPRCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compdigit44Author 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....
0
QPRCommented:
Yes that is the same thing
0
compdigit44Author Commented:
Should I run an update stats job daily????
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.