Browse by Tags

• Best Practices
• Performance

• Flash Memory and Databases

  Right now, flash memory-based solid state drives are still more expensive than traditional disk drives in terms of the cost per gigabyte. But flash-based drives or some type of hybrid that combines both flash and traditional disk drives seem to be coming. Read More... Posted Friday, January 04, 2008 9:59 PM by Linchi Shea | 9 Comments Filed under: Architecture, Storage

• 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