Gustav Brock
gustav at cactus.dk
Wed Feb 19 03:46:41 CST 2014
Hi John Thanks. Proves that you often should think out of the box. /gustav -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af John W Colby Sendt: 18. februar 2014 21:48 Til: Access Developers discussion and problem solving Emne: Re: [AccessD] How StackOverflow Scales with SQL Server (Video) | Brent Ozar UnlimitedBrent Ozar Unlimited This was a very interesting video. My favorite was "Newegg you way out of problems" (or thereabouts). That was my exact strategy when I built a server. 96 GB RAM, a terabyte SSD raid 6 to hold my core databases, and tons of cores (SQL Server 2008). Then data compression to maximize the data in memory and minimize the IO. Keep those cores busy. That said I just created a new index on each database (compressed of course) specifically aimed at my "Everything by Everything"count process, which dropped the count time from a day per hash down to about an hour / hash. Anyway, take the time to watch the video. John W. Colby Reality is what refuses to go away when you do not believe in it On 2/18/2014 3:05 PM, John W Colby wrote: > http://www.brentozar.com/archive/2011/11/how-stackoverflow-scales-sql-server-video/