John W Colby
jwcolby at gmail.com
Tue Feb 18 14:47:31 CST 2014
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/ >