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

This is practically the same strategy that Oracle took....which I am working
with right now.
It's called Exalytics.


> 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