coppereye anyone ? .... and onchecks
Posted in 2006
Topics: Third-Party Tools & Monitoring
We are running into the time crunch issue. We have huge tables that need index rebuilds, and can't find the time easily to do them.
I understand Coppereye can build indexes very rapidly, and can build them online without locking the table. I remember seeing a chat with labs about that about 1.5 years ago and was very impressed.
Is anyone using that datablade ??
On the same note, we also don't have time to do proper oncheck cDI's due to the shared lock they put on tables and our need for 24 hour availability.
Is anyone else in this same boat ? What is the solution. One solution we are thinking about is to restore the database to another test server and do the onchecks on that. However that is a very expensive solution.
Thanks,
Floyd
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Home: 703-430-0805
Cell: 703-477-6045
========================
http://www.one.org/
Floyd Wellershaus wrote:
> On the same note, we also don't have time to do proper oncheck cDI's due to the shared
>lock they put on tables and our need for 24 hour availability.
>
> Is anyone else in this same boat ? What is the solution. One solution we are thinking
> about is to restore the database to another test server and do the onchecks on that.
> However that is a very expensive solution.
This is the solution that we use. If your running HDR can you oncheck
on the secondary? Probably not while it is linked.