Solved

Sharepoint 2010 DB Stats

Posted on 2014-02-26
5
568 Views
Last Modified: 2014-02-27
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
Comment
Question by:compdigit44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 39890075
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
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 39890077
0
 
LVL 20

Author Comment

by:compdigit44
ID: 39890488
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
 
LVL 29

Expert Comment

by:QPR
ID: 39890545
Yes that is the same thing
0
 
LVL 20

Author Comment

by:compdigit44
ID: 39890573
Should I run an update stats job daily????
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question