Mirroring tempdbspaces
Posted in 1999
Topics: Storage & Space Management
Hi all I have a customer who is fairly insistent on mirroring (at OS level) temp dbspaces. I think this is a bad idea, especially as I don't really have enough disk to play with. Whilst all my other systems are mirrored, I've never mirrored temp dbspaces before. What does the panel think? Does anyone else here do this? Cheers, Jon.
It depends on the criticality of the system. While I normally wouldn't bother to mirror temp DBSpaces, there are systems where uptime must be kept to a maximum. If termination of a query due to a bad chunk within a temp DBSpace is unacceptable, then mirroring is mandatory. Troy Jon Myatt <jon@webpower.co.uk> wrote in message news:37C3B2BA.A272DF01@webpower.co.uk... > Hi all > > I have a customer who is fairly insistent on mirroring (at OS level) > temp dbspaces. I think this is a bad idea, especially as I don't > really have enough disk to play with. > > Whilst all my other systems are mirrored, I've never mirrored > temp dbspaces before. > > What does the panel think? > > Does anyone else here do this? > > Cheers, > > Jon.