Category Archives: Computer Hardware

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket servers. These processors have slightly better single-threaded performance than the previous 32nm Xeon E5-2600 Family (Sandy Bridge-EP) processors, along with … Continue reading

Posted in Computer Hardware, Intel, Ivy Bridge-EP, SQL Server 2012 | Tagged | 3 Comments

Hardware 201: Selecting and Sizing Database Hardware

On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download my deck here. Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance The foundation of database performance is the … Continue reading

Posted in Computer Hardware, Intel, Processors, SQL Server 2012, Teaching | Tagged , | Leave a comment

Speaking in Denver and Boulder in June

I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL Server User’s Group on June 20, 2013. In both cases, I will be presenting an updated version of  Hardware 201. … Continue reading

Posted in Computer Hardware, PASS, Teaching | Tagged | Leave a comment

New Immersion Event Classes at SQLskills

There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the two-day IEHW class on September 18-19. I am really excited to get the chance to teach the IEHW class, and … Continue reading

Posted in Computer Hardware, SQL Server, Teaching | Tagged , | Leave a comment

Hardware 301 Presentation

I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times in one day yesterday! First was a virtual presentation for the PASS Virtual DBA chapter at 12PM, and then I … Continue reading

Posted in Computer Hardware, Processors, Sandy Bridge, SQL Server 2012 | Tagged | 3 Comments

Speaking at PASS Database Administration Virtual Chapter

I will be speaking at the PASS Database Administration Virtual Chapter on February 13, 2013 at 12PM MST. I will be presenting the latest version of my Hardware 301: Diving Deeper into Database Hardware deck. The LiveMeeting link is here. … Continue reading

Posted in Computer Hardware, PASS, Processors, Storage Subsystems | Tagged | 1 Comment

SQL Server 2012 Standard Edition Licensing Limits

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware. As a DBA and consultant, I would like to … Continue reading

Posted in Computer Hardware, Microsoft, SQL Server 2012 | Tagged , | 12 Comments