On an EMC array is it possible to assign WRITE cache to wherever your transaction log files are?
Yes, 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 disable […]
Should a VMs virtual disks all be on the same storage?
A 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. […]
Getting rid of those annoying backup successful messages
If you have a SQL Server, and you are doing transaction log backups on the database server you’ll notice that 99% of the messages in your ERRORLOG file are worthless. All they say is that the log was backed up successfully. Personally I don’t care that every 15 minutes all 30 databases had their logs […]
Let your opinion be heard for SQL PASS.
I’m a couple days late getting this post out, thanks to being at EMC World, but here it is. This year the PASS Summit is asking for your help in deciding what sessions should be presented at the SQL PASS summit in Seattle later this year. To do this they have created the Session Preference […]