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 […]
I’ll be presenting a pre-con at #sqlsat62 in Tampa, FL.
If you wanted to go to my pre-con at the SQL PASS Summit, but you couldn’t make it, or you couldn’t get the boss to approve the $400 price tag that PASS was charging do I have a deal for you. I’ll be presenting the same pre-con (hopefully better after integrating feedback from the PASS […]
What are the best counters or KPIs to identify what drives would benefit from EFD’s and can be used to reflect before and after performance metrics?
EFDs (Enterprise Flash Disks) or SSDs (Solid State Disks) are all the rage today for systems which have very high IO load requirements. But knowing if your disks would benefit from this technology can be a bit of a problem if you don’t know where to look. After all these disks are not cheap. Some […]