Solved

Sharepoint 2010 DB Stats

Posted on 2014-02-26
5
570 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

635 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