[AccessD] How StackOverflow Scales with SQL Server (Video) | Brent Ozar UnlimitedBrent Ozar Unlimited

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/



More information about the AccessD mailing list