Timeline for Parallel Statistics Update
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 5, 2012 at 20:01 | comment | added | SQL Learner | it is ok darin... | |
| Jul 5, 2012 at 16:10 | comment | added | Darin Strait | You are right, with respect to the white paper and sql2008. I just read that white paper; the info in my head is out of date. I had many problems with either sql2005 or maybe even sql2000 with respect to reindexing, UPDATE STATISTICS, FULLSCAN vs. SAMPLE, time required for jobs and the stochastic quality of the data on the stats pages. I guess that all of that pain is water under the bridge now. I would say that you could run UPDATE STATS on different tables in parallel, but that seems like more trouble than it's worth and you may have too much I/O contention for it to be worthwhile. | |
| Jul 5, 2012 at 0:45 | comment | added | SQL Learner | Jon Seigel, found and read the whitepaper after posting the question however seraching the web still not sure whether update statis can use parallelism. | |
| Jul 4, 2012 at 18:58 | comment | added | Jon Seigel | @SQLLearner: No offense, but regardless of the correctness of this answer, why are you asking this question if you've read that whitepaper? It gives you an answer to everything you've asked. If you're not seeing parallelism for your specific scenario, then please edit the question to state that, and any other relevent details. | |
| Jul 4, 2012 at 17:15 | comment | added | SQL Learner | Also, update stat takes schema stability lock so if you run other update stats it will wait until earlier one completes. | |
| Jul 4, 2012 at 17:11 | comment | added | SQL Learner | I apologize for mark down but you have no idea what you are talking about. From this whitepaper msdn.microsoft.com/en-us/library/dd535534(v=sql.100).aspx "Parallel statistics gathering for fullscan: For statistics gathered with fullscan, creation of a single statistics object can be done in parallel for both nonpartitioned and partitioned tables." However I am not able see parallelism when I use UPDATE STATISTICS with full scan on 30 million rows table | |
| Jul 4, 2012 at 13:25 | history | answered | Darin Strait | CC BY-SA 3.0 |