Some Good SQL Server 2005 I/O Related Information

Linchi Shea, who is a SQL Server MVP who I got to meet at the 2007 PASS Summit has yet another good post about SQL Server 2005 I/O issues. This one measures the effect of read and write cache in disk controllers. It turns out, according to his tests, that read caches in disk controllers don’t help SQL Server very much, while write caches are much more helpful. The nice thing about Linchi is that he does not just accept conventional wisdom at face value, he believes in doing empirical testing and presenting the results. 

Joe Chang, who is extremely knowledgeable about SQL Server related hardware, has a very interesting post about storage performance for SQL Server. He also has several other good recent posts about the various TPC benchmarks and SQL Server hardware sizing.  I have to agree with him that the current sweet spot for most general purpose SQL Server 2005 installations is a two socket, quad-core Xeon X5460 3.16GHz, 2x6MB L2 cache, 1333MHz FSB system (using 45nm Penryn based technology). This gives you eight cores, with larges shared L2 caches, and a very fast FSB. It also minimizes your SQL license costs (since Microsoft licenses by physical CPU socket).

Something like a Dell PowerEdge 2900 III, can be filled up with 48GB of RAM, some internal drives for your OS and page file, and some HBAs to talk to your SAN, and you will have a very capable eight core machine.

This entry was posted in SQL Server 2005. Bookmark the permalink.

8 Responses to Some Good SQL Server 2005 I/O Related Information

  1. Unknown says:

    welcome to visit RF online blog Mmo blog Mmo guide blog Internet game guideTales of pirates forum ,it will give your some help.EVE online isk cheap EVE isk Guild wars gold Guild wars money GW gold Rs Money Wow gold Wow World of warcraft Gold Wow eu gold Wow us gold Maplestory mesos WOW GOLD worlf of warcrraft  World of warcraft gold Runescape RS gold RF online RF online cp RF online dalant  RF online disena  RF online money RF online gold Lotro gold Buy lotro gold  WOW gold  Cheap wow gold on sale. and you can sell your gold to us.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s