John W Colby
jwcolby at gmail.com
Wed Feb 19 06:48:11 CST 2014
It is amazing the performance they got "per server". Also the live update of the statistics as things happen behind the scenes. Just a fascinating video. John W. Colby Reality is what refuses to go away when you do not believe in it On 2/19/2014 4:46 AM, Gustav Brock wrote: > 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/