May 3, 2016 at 9:31 am
Is there a way to get the history of statistics update? I know you can easily query the last statistics update date, but I want to know the history of when statistics updates happened on several tables. I've search the Internet and haven't found much other than how to get the last update date.
Reason: I have a process that seems to get slower and slower until one day it just blazes right along, but then starts to get slower and slower again until one day it just blazes away again. I'm trying to figure out what is being done for it to suddenly start blazing again. Was it an index rebuild? An index reorganization? Statistics updates? Something else?
Thanks if in advance for any ideas,
Pat B
Pat Buskey
May 3, 2016 at 9:40 am
bustell (5/3/2016)
Is there a way to get the history of statistics update?
Not unless you have some manual process that's been keeping track of it.
I would suggest you track that query's execution plan day by day (pull it out of cache), then you can compare slow to fast and see what's happening.
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
May 3, 2016 at 9:47 am
bustell (5/3/2016)
Not unless you have some manual process that's been keeping track of it.
I was afraid of that and kind of figured. Thanks. 🙂
The problem with monitoring the query plan, is that there several queries in the process and I'm not even sure which one of them is the issue yet. Was hoping to correlate performance by hour to when indexes were reorganized, rebuilt or when stats were updated to give me some clues.
The search goes on (and of course I don't have much time to work on the issue either).
Pat B
Pat Buskey
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply