Hi,

I'm having negative experience with Diskeeper. It's locking us out of SQL when it's defragging the server. Defrag is scheduled weekly on Saturdays when we usually aren't hitting the db.

I'm running Win2003 Server and SQL 2000 on Raid 5 array. Two db's with the problem are 66 and 50 Gb each. Hard drive is 410 GB with 50% free.

First noticed it 3 weeks ago when a db maintenance job blew up. Changed it to complete before the defrag began and this worked.

However, a few data entry folks were in this Saturday am and could no longer access the db as soon Diskeeper started. Totally locked out. And PO'd.

From the thread it sounds like this shouldn't happen with Diskeeper. Is there an option/setting that we're missing?

Other than scheduling the defrag for later on Saturday, looking for a better solution.

Any ideas? Our network admin told me SQL has a defrag function. Since I already regularly defrag indexes weekly I'm not sure what he's talking about.

Thanks