Re: DBAs and System Managers - War and Peace?

|> >I started consulting for a company and suggested to the system
|> >manager that we should mirror the log files to two or more disks
|> >and possibly separate some data files. Right now the entire
|> >database is on a single disk.
|> >
|> >He jumped at this and swore that he would never do it. He further
|> >indicated that my predecessor wanted the same thing (surprise!)
|> >and that we were crazy.
|> >
|>
|> So, what's the point? You might want to have the SysAdmin people run whatever
|> utilities they have (if this is Unix, SAR would be a good place to start)
|> to look at the activity on the dis. If there's a bottleneck, then that
|> should be reason enough to move things around. If there's no bottleneck, then
|> I would have to agree with him.
|>

This was just another experience showing that those disagreements exist.

Our particular concern was not performance but recovery. The usual recommendation is to mirror your control and log files in case of a disk failure.

Richard

-- 
Richard G. Ramirez, Ph. D.
Assistant Professor of MIS
Iowa State University