[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SP_autostats is "ON" but Last updated column is three months old

Posted on 2008-10-14
1
Medium Priority
?
510 Views
Last Modified: 2008-10-29
Hi Experts,
I ran Exec SP_autostats Employee... the AUTOSTATS cloumn is "ON" for all indexes, but the last update shows Jul (more than three months ago)

Can someone explain what is missing here?
0
Comment
Question by:sir-rob
1 Comment
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 22718572
even with autostats, statisitcs are collected only when some thresholds are being met
if your table hasn't been updated much in the last 3 months, it is possible that the statistics that were calculated 3 months ago are still relevant and that is why sql server didn't update them
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

834 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