November 2012 - Posts

• Queries barely over the Cost Threshold for Parallelism

  I had discussed SQL Server parallelism in Oct 2010, with my thoughts on the best settings for: Cost Threshold for Parallelism (CTP) and Max Degrees of Parallelism (MAXDOP) in Parallelism Strategy and Comments . At the time, I had intended to follow up Read More... Posted Thursday, November 15, 2012 4:11 PM by jchang | 5 Comments

• SSDs at PASS 2012

  There were 7 companies exhibiting SSD products as PASS this year, and one with a product to support SSD storage. This is not counting Dell, EMC and HP who have SSD products, but were at PASS for other reasons. This shows that many have aspirations with Read More... Posted Friday, November 09, 2012 1:30 AM by jchang | 1 Comments

• SSD-HDD price parity

  It is hard to believe that we are essentially at SSD-HDD price parity? Of course I am comparing enterprise class 10K/15K HDDs to consumer grade SSDs. Below are prices I am seeing 600GB 15K 3.5in HDD $370 3TB 7.2K 3.5in HDD $400 300GB 15K 2.5in HDD $370 Read More... Posted Monday, November 05, 2012 10:21 PM by jchang | 0 Comments