SQL Saturday #62 looks like it is going to be a great event
The first SQL Saturday of 2011 is looking like it is going to be an awesome event. One reason that I can say that a month ahead of time is that for the first time (as far as I know) speakers have to be turned away because there have just been so many speakers submitting […]
Do we have to worry about disk alignment if we have an EMC san?
Yes. Every storage platform no matter what vendor makes it needs to be correctly aligned. If the disks aren’t correctly aligned then you are doing twice as much work for every read and write operation than you need to be doing. Fortunately new volumes created on a Windows 2008 or higher server (or Vista or […]
Microsoft SQL Server’s MDS has come a long way.
OK, now that I have your attention pretty much nothing has changed in Denali’s Master Data Services. The install procedure is a bit different now but that is about it. To install the Denali version of MDS just run through the normal SQL Server installer. When you get to the service list page scroll to […]
Will separation of data file and log file of SQL sever help if all are on the SAN? From performance perspective not management.
Most likely yes, but it really depends on the storage array and the storage array configuration. If the array is a shared everything array like an IBM XIV then their may not be any benefit to breaking everything onto separate disks as each LUN is spread over every spindle in the device. However if you […]