![]() 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. What makes/models of the SAN support it?.Is the backup process completely automated without scripting? (Meaning, if the customer has to roll their own scripts, is there any examples you can point to?).How many LUNs do I need to accomplish that goal?.Be able to restore any of the databases individually to the snapshot, and be able to restore any of the smaller databases to a point in time.Sync any of the databases over the WAN to a second SAN.Back up the 5 smaller 20GB databases with transaction log point-in-time recovery abilities.Back up any of the databases individually, at any time, with snapshots.TempDB – eight data files and one log file.5 smaller 20GB configuration databases – each with 1 data file and 1 log file. ![]()
0 Comments
Leave a Reply. |