September 27, 2012 at 7:33 pm
Auto update statistics is enabled but statistics are not updated.
Not updated statistics may cause database slowdown? Why they are not updated.
Thanks.
September 28, 2012 at 5:26 am
Statistics are only updated when they need to be. If the data hasn't changed significantly enough to require them to be updated, then it won't bother.
September 28, 2012 at 5:36 am
Why do you say they are not being updated?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2012 at 6:00 am
Check and post results of the following query
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on t.object_id = i.object_id
where t.is_ms_shipped <> 1
order by statistics_update_date desc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 6:10 am
Perry Whittle (9/28/2012)
Check and post results of the following query
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on t.object_id = i.object_id
where t.is_ms_shipped <> 1
order by statistics_update_date desc
Rather use sys.stats, not sys.indexes. Column stats (whether manually or automatically created) aren't in sys.indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2012 at 8:12 am
GilaMonster (9/28/2012)
Rather use sys.stats, not sys.indexes. Column stats (whether manually or automatically created) aren't in sys.indexes.
yes, of course, my bad
marygrace_laurente23 (9/27/2012)
Auto update statistics is enabled but statistics are not updated.Not updated statistics may cause database slowdown? Why they are not updated.
Thanks.
Please review and post the results of the following query
SELECTOBJECT_NAME(s.object_id) AS TableName
, s.name
, STATS_DATE(s.object_id, s.stats_id) AS StatsDate
FROM sys.stats s
INNER JOIN sys.objects o on
s.object_id = o.object_id
WHERE o.is_ms_shipped <> 1
ORDER BY 1, 3 DESC
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply