Browse by Tags

• .NET
• Best Practices
• Storage
• Testing

• Amdahl’s Law

  For the past few weeks, I’ve been working on a diverse array of issues ranging from studying SQL Server performance on various multi-core processors, pondering the implications of many-core processors, troubleshooting SQL Server performance problems, Read More... Posted Tuesday, February 12, 2008 12:43 AM by Linchi Shea | 16 Comments Filed under: Performance, Architecture

• Where does Time Go?

  A significant part of my job is to evaluate how SQL Server (and sometimes other DBMSs) performs on various hardware platforms, in particular on the processors and its related chipsets as they are being released. So naturally, I’ve been paying attention Read More... Posted Wednesday, January 02, 2008 1:02 AM by Linchi Shea | 5 Comments Filed under: Performance, Architecture

• Best and Worst Checkpoint Performance

  The best documentation on the I/O behavior of SQL Server checkpoints is found in SQL Server 2000 I/O Basics by Bob Dorr. In particular, you should read the following carefully: SQL Server uses the following steps to set up another page for flushing and Read More... Posted Thursday, November 01, 2007 1:05 AM by Linchi Shea | 6 Comments Filed under: Performance, Architecture, Storage, Best Practices Attachment(s): Best_checkpoints.gif

• Hash Partition as a Design Method

  SQL Server 2005 does not support hash partition as a product feature. But that doesn't mean you can't apply the concept of hash partition in your application or database design. Recently, I worked on an application that used SQL Server to persist the Read More... Posted Monday, January 22, 2007 10:35 PM by Linchi Shea | 1 Comments Filed under: Performance, Architecture, .NET Attachment(s): HashPartition.gif

• 32-bit vs. x64

  When it comes to the issue of 32-bit vs. x64, you can easily walk away from a presentation with an impression that going to x64 will most likely give your SQL Server application a performance boost. I'd like to show you--with some test data--that you Read More... Posted Tuesday, January 02, 2007 12:02 PM by Linchi Shea | 5 Comments Filed under: Performance, Testing, Architecture