May 23, 2011 2:00 PM
Posted by: Denny Cherry
EMC,
SQL Server,
StorageYes, provided that your transaction logs have their own LUN from the other files as the write cache is enabled and disabled at the LUN level. By default read and write cache will be enabled for every LUN which is created on the array.
There aren’t to many cases where you would want to...
May 19, 2011 11:00 AM
Posted by: Denny Cherry
SQL Server,
Storage,
VirtualizationA question that comes up when building a new virtual SQL Server is how should the disks be laid out when using the default VMDK (VMware) or vDisks (Hyper-V)? Should the disks be on a single LUN, or different LUNs, etc.
I’m sure that it will surprise no one when I say that it depends. On a...
May 11, 2011 4:16 PM
Posted by: Denny Cherry
EMC World,
EMC World 2011,
GreenPlum,
SQL Server,
VMware,
VNX,
VNXeYesterday was EMC World day 2 and it was another great day at the conference. I started the day a little late as I was out pretty late on Monday night at a party. I was abe to great some great sessions in during the day however.
The first session that I hit was "SQL Server on VMware -...
May 10, 2011 2:00 PM
Posted by: Denny Cherry
EMC World,
EMC World 2011,
SQL ServerSo today was the first official day of EMC world. I had a great time meeting some fantastic people like Chuck Hollis from EMC.
There were also some fantastic sessions. This year EMC is doing something new and putting the sessions online through an iPad app as well as putting them on their...
May 9, 2011 2:00 PM
Posted by: Denny Cherry
EMC World,
EMC World 2011So today began EMC World 2011. It started in true EMC style with a great party, sponsored by UniSys. The party was held at the Hotel pool which seems a little strange but EMC made it work. It was a little windy last night, apparently not even EMC can control the weather.
I met some great...
May 5, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
StorageI would say that the SAN admins are nuts if they think that the DBAs aren’t going to worry about storage performance. There is no magic SAN dust which keeps everything running fast all of the time. If you put enough load on the array then performance will be impacted, no matter how many disks...
May 2, 2011 2:00 PM
Posted by: Denny Cherry
EMC World,
EMC World 2011So this year EMC World is back in Las Vegas, and I'm damn happy that I'm going again. Instead of taking the quick flight from Ontario to Las Vegas like I normally word, I'll be getting there a little differently, I'll be riding my motorcycle.
As I can only...
April 28, 2011 2:00 PM
Posted by: Denny Cherry
StorageThe biggest recommendation that I have (pretty much the only one since I haven’t worked with a 3PAR in a while) is to ensure that your LUNs are sized correctly so that they are evenly spread out across all the disks in the disk set that you are using.
For example, if you have 100 disks in the...
April 25, 2011 2:00 PM
Posted by: Denny Cherry
Index,
Index Scan,
Index Seek,
SQL Server,
StorageThere are a few things which you will want to look at. First make sure that you have enough RAM for the database to use. Without enough RAM in the SQL Server you’ll begin putting extra load on the disks because the same data is being pulled into the buffer cache from the disk over and...
