February 4, 2008 at 3:13 am
Someone pls point to some articles that decsribe, how statistics is maintained and managed internally (similar to index architecture)
February 4, 2008 at 4:38 am
This white paper from Microsoft is one of the best sources for this information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2008 at 10:03 pm
Thanks, but I meant the storage and architecture of stats.
February 5, 2008 at 5:42 am
Sorry that wasn't helpful. I thought that covered most everything. However, for drill down, one place I go is the Query Procesing Team blog. This is the Storage Engine team's blog. It has some information that might be useful. Those are the references that I have at hand. What specifically are you looking for that wasn't covered by the statistics used for indexing white paper?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2008 at 2:10 am
I am looking for details on how the histograms are stored inside and how they are managed byy sql server, on a very low level.
February 6, 2008 at 2:27 am
May I ask why you're interested?
In SQL 2005, all the implementation details of stats are hidden. On SQL 2000 it was possible to see the statsblob (an IMAGE column iirc) in sysindexes. In 2005, even that's dissapeared. I spent some time a while back looking through the system tables to see if I could find where the stats are stored. Had no luck.
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
February 6, 2008 at 3:20 am
I was wondering if someone in the community knows the implementation details.
February 6, 2008 at 3:47 am
Possibly someone formerly or currently on the dev team would know. There doesn't seem to be much available on the internals of statistics
Conor Cunningham[/url] indicated he might be writing on stats in the future. There's nothing on his blog rght now on stats internals, but maybe in the future. Or you could mail him and ask.
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
February 6, 2008 at 4:53 am
Yes Gail before asking for a new post, I wanted to know whether something has been already written. Thanks for your help!
February 6, 2008 at 3:39 pm
* Noel
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply