Re: Normalization question

"Erland Sommarskog" <sommar_at_algonet.se> wrote in message news:Xns923BEB3D79DD2Yazorman_at_127.0.0.1...
> Jerry Gitomer (jgitomer_at_erols.com) writes:
> > Given the cost of disk storage space I think you would be
> > better off optimizing for performance and ignore disk space
> > consumption. As a DBA I have never heard users or management
> > complain about needing more disks, but I have frequently heard
> > complaints about performance.
>
> Well, we have had complaints about backups and things like that taking
> too long time. And that kind of performance is indeed directly related
> to disk usage.

On a similar note, I'm facing a system where I'm running out of disk space. (It's 17 gig now, I need a few gig more).

Unfortunately, it's a RAID 1+0 system, so upgrading is a matter of adding 4 drives, not just 1.

(On other systems I have as many as 8 drives RAIDed, so upgrading for disk space CAN get expensive quickly.)

In general though I'd agree with Jerry, but I have had management complain about the cost of drives. :-)

>
>
>
> --
> Erland Sommarskog, SQL Server MVP
> sommar_at_algonet.se
> Books Online (updated!) for SQL 2000 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Received on Fri Jun 28 2002 - 23:55:53 CEST