Browse by Tags

• Performance
• SAN

• Performance Impact: Manual Checkpoints are not Necessarily Evil

  In my two previous posts on the performance impact of frequent manual checkpoints and the I/O behavior of frequent manual checkpoints , I demonstrated that frequently issuing manual checkpoints can be bad for performance and why it's bad from the storage Read More... Posted Monday, August 20, 2007 3:27 PM by Linchi Shea | 2 Comments Filed under: Performance, Testing, Storage, Best Practices Attachment(s): checkpoint3.gif

• Performance Impact: Frequent Manual Checkpoints and Their I/O Behavior

  In my previous blog post on the performance impact of frequent manual checkpoints , I highlighted the performance peril of going overboard with manual checkpoints, and I suggested that a major contributing factor was the failure of frequent manual checkpoints Read More... Posted Friday, August 17, 2007 11:57 PM by Linchi Shea | 6 Comments Filed under: Performance, Testing, Storage, Best Practices Attachment(s): checkpoints2.gif

• Performance Impact of Using NTFS Compression with Read-Only Databases

  SQL Server 2005 supports placing read-only filegroups or read-only databases on NTFS compression. In other words, you can compress the database files in a read-only filegroup or a read-only database. This can be a very useful feature if saving disk storage Read More... Posted Friday, May 04, 2007 3:23 AM by Linchi Shea | 3 Comments Filed under: Performance, Testing, Storage, Best Practices

• Should I Use a Windows Striped Volume?

  In Windows Server 2003, you can use the Disk Management console to create a striped volume over multiple dynamic disks (well, you can also create a mirrored, a RAID-5 volume, etc). If these disks (or LUNs) are presented from a SAN, most likely you can Read More... Posted Monday, March 12, 2007 1:25 PM by Linchi Shea | 11 Comments Filed under: Performance, Testing, SAN, Storage, Best Practices Attachment(s): WindowsStriped.gif

• Performance Impact of Disk Misalignment

  Just google for Windows disk alignment best practice , and you would find thousands of articles, whitepapers, and posts, all preaching the practice of aligning disk partitions on the 64K boundary. For instance, one of the EMC recommendations prescribes Read More... Posted Thursday, February 01, 2007 8:04 AM by Linchi Shea | 16 Comments Filed under: Performance, Testing, Storage, Best Practices Attachment(s): diskAlign.gif