C
ChUIMonster
Guest
On 12/5/14, 4:51 AM, Jimmer wrote: RE: Quick Raid quiz 
Reply by Jimmer some businesses do. Businesses do foolish things. That particular choice borders on suicidal. Others use 3-5 online incremental backups during work hours to alleviate, so... Very, very few modern businesses can actually "rekey" several hours of lost work. And if external systems are involved reconciling the data feeds and safely eliminating duplicate transactions becomes quite a challenge with even the smallest window of lost data. After-imaging is the DBAs best friend. Running without it is stupid. Consider that the AI are on separate disks, what would be your advice regarding the 8 remaining? Knowing nothing else and having no insight into the workload or the application but extrapolating from "no ai" that it must be a relatively small and lightweight system I would build a single RAID 10. Even if it is larger I would probably go that way. Discrete disk for the BI file only really works if there is just a single database. Many, possibly most, systems are composed of multiple databases and thus have multiple bi logs. In those cases the benefits of having a single drive that is accessed mostly sequentially are lost so you are better off combining them all. Of course gathering real data about the systems actual workload and performance could change my mind. -- Tom Bascom 603 396 4886 tom@greenfieldtech.com
Continue reading...
Reply by Jimmer some businesses do. Businesses do foolish things. That particular choice borders on suicidal. Others use 3-5 online incremental backups during work hours to alleviate, so... Very, very few modern businesses can actually "rekey" several hours of lost work. And if external systems are involved reconciling the data feeds and safely eliminating duplicate transactions becomes quite a challenge with even the smallest window of lost data. After-imaging is the DBAs best friend. Running without it is stupid. Consider that the AI are on separate disks, what would be your advice regarding the 8 remaining? Knowing nothing else and having no insight into the workload or the application but extrapolating from "no ai" that it must be a relatively small and lightweight system I would build a single RAID 10. Even if it is larger I would probably go that way. Discrete disk for the BI file only really works if there is just a single database. Many, possibly most, systems are composed of multiple databases and thus have multiple bi logs. In those cases the benefits of having a single drive that is accessed mostly sequentially are lost so you are better off combining them all. Of course gathering real data about the systems actual workload and performance could change my mind. -- Tom Bascom 603 396 4886 tom@greenfieldtech.comContinue reading...