January 2010 - Posts

• Auto-tuning memory configuration on a cluster

  I was inspired by Aaron's post on a similar topic a while back to dig deeper into how I could automagically adjust the memory allocation for multiple instances of SQL Server in a cluster-failover scenario. So, suppose you have: A two-node cluster Four Read More... Posted Friday, January 22, 2010 10:13 AM by merrillaldrich | 9 Comments

• OT: Mac++

  Mac++ | C:\macOSX > bliss It’s been about eight years (!) since my wife and I bought a computer for personal use. Last week we took delivery of a new MacBook Pro 13 2.26. And it’s fantastic! Sometimes if I work on a machine that’s slightly newer than Read More... Posted Friday, January 22, 2010 12:02 AM by merrillaldrich | 4 Comments

• Poll: Hyperthread or not on 2 x 4 core Nehalem SQL Server?

  Common wisdom with previous generations of server hardware was that SQL Server might not benefit from hyperthreading or could be degraded at high CPU usage; does anyone have definitive data about Nehalem (non-EX) servers and SQL Server 2005 or 2008? Here Read More... Posted Thursday, January 14, 2010 3:05 PM by merrillaldrich | 2 Comments Filed under: performance, hyperthreading