I'm working in a large cor****ate data center with a typical EMC (Like)
data storage array. I don't know exactly what it is... But it's some
sort of storage system. I have a co-worker who is convinved that
performance can be improved by specifying what segments to place the
database on. An active database gets it's own disk and so on.
Now I've been at this for a while and I know that this sort of
optimization was done in the past. But when I have an SQL server
connected to one of the modern storage devices, is the concept of
segments and disks relevant anymore? I know there are segments defined
on my dataserver. But as far as I know, that's an abstraction to humor
me. My hardware huy tells me that these devices have something of
their own OS and one never really knows how it's deciding to store
data. Let alone where exactly.
Am I more wrong then right or visa-versa?
Wayne
