Optimization Locks up database

[Schaeffrcc]

I have a SQL 7.0 Server that serves up 4 databases. For the last month we have been having problems on Sunday nights when we run our DB optimization job the DBCC command ends up locking the database on one of the 4 databases. On Monday morning we end up having to kill the Optimization Job to get users to be able to log into the SQL application.

I have looked around and not found the cause of this hang up. Can anyone give me an idea or direction that my help me figure out the cause of this lockup.

What does this optimization job try to do? That may put me on a path that helps me find the cause in the data.

As an aside and I do not know if it is related but we have be having problems with individul users also locking tables in the database by just doing what looks like select queries to get a list of clients.

Thanks for any help you can give me.

Thomas.

 

[ram1975]

Can u be a bit more specific what type of optimization you are trying to do? i.e. the DBCC commands u are using ?

 

[Schaeffrcc]

We are running a standard SQL maintenance plan and it looks like the optimization job is running a xp_sqlmaint on the master database.

I hope this helps,

Thomas.