Totals: 26 LUNs or 18 LUNs (consolidated) The answer is based on the limited info… we hadĥx 20GB config(Consolidated) - 2 LUNs (1 data, 1 log) I do not know about your TempDB workloads and the real reasons behind so many data files, is it purely following best practice (files to cores)? is it needed for raw disk I/O performance? is it needed to reduce SGAM/GAM waits/latches, etc….but I will take a stab at somewhere in the middle and allocate two data files per LUN…Īt EMC we don’t want to guess, we don’t want to assume, we attempt to work out what the best fit is for the business and application requirement… Now, in terms of smaller, less I/O intensive databases which workloads tend to be similar and also all five are required to be logically consistency in order for the top-level application to function… then it is entirely acceptable, given the right consideration to consolidate these database data files and logs into the same volumes, so I will provide some considerations below Sounds complex, right? Trust me, it’s not, check out this demo: This also allows our replication management product Replication Manager to perform partial file-group recovery. Using Microsoft SQL Server and of course SQL CAT best practices, each data and log file should be allocated a dedicated volume (LUN). Why keep older, colder data on EFD or Fibre Channel when it could sit well on SATA disk. With this in mind, the first thing you should consider is minimizing the cost of underlying storage of the colder data and maximizing the performance of the hotter data (latter partition data files) by using EMC FAST (Fully Automated Storage Tiering). How many LUNs do I need to accomplish that goal?Ĭonsider you are already using a partitioned database and considering you have put this in DW terms as opposed to dedicated OLTP SQL environment, the assumption here is that you are partitioning more for aged data over performance, i.e. I collected some inputs from some of the engineers in our Proven Solutions team: You can email me directly, or post the responses here in comments. If your SAN can do it, I’d love to hear about it.
0 Comments
Leave a Reply. |