[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

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?
0
compdigit44
Asked:
compdigit44
  • 3
  • 2
1 Solution
 
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
 
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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now