How much cache to allocate for servers that host 500gb databases?
The short answer is as much as possible. The more exact answer is you typically can’t allocate cache to a specific LUN. You can usually carve up the total amount of cache into read and write cache. You want as much write cache as possible so that the database writes directly to the disk as […]
What are your opinions on using an iSCSI NAS for SQL Server storage?
You’ve really got two questions here. The first is if I like iSCSI for SQL, and the second is if I like NAS for SQL. NAS doesn’t support iSCSI as iSCSI is a SAN technology. iSCSI is just fine for SQL Server as long as the server and the storage are on the same subnet, […]
Donuts, Coffee, Lunch and an MVP for $99.
This great phrase (which is way more clever than anything I could come up with) was tweeted by Daniel Taylor (Twitter) last week while talking about the pre-cons which are coming up this week in Tampa. And today is the last day to sign up for $99 (plus a few bucks for fees). After today […]
Lets get session state out of the database, and into memory where it belongs.
One of the all to common configuration mistakes that are made is to put the session state within the SQL Server when a website begins to scale to multiple web servers. Some background For those that don’t know what session state is, let me take a step back and fill you in. Session state allows […]