DBCC SHOWCONTIG

Hi all
I am using the DBCC SHOWCONTIG of a table(EquipmentStatus)
in one of my scheduler.
DBCC SHOWCONTIG ('EquipmentStatus')
WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS
At the same time this table 'EquipmentStatus' is inserted
by records by an application very often.
Sometime Timeout error occurs in the application. When
analysed I found that when DBCC SHOWCONTIG was running it
locks the table. So the application time out.
It happens not every time bu occassionally. Is it a good
method to run DBCC SHOWCONTIG when the Database is ONLine?
Thanks in advance
Anand.For a matter of fact run DBCC (Database Consitency Checker) commands at
off-peak load times and during the nights using a Job / Maintenance Plan ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Anand" <gurusanand@.sifymail.com> wrote in message
news:04b301c37818$11f65390$a401280a@.phx.gbl...
> Hi all
> I am using the DBCC SHOWCONTIG of a table(EquipmentStatus)
> in one of my scheduler.
> DBCC SHOWCONTIG ('EquipmentStatus')
> WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS
> At the same time this table 'EquipmentStatus' is inserted
> by records by an application very often.
> Sometime Timeout error occurs in the application. When
> analysed I found that when DBCC SHOWCONTIG was running it
> locks the table. So the application time out.
> It happens not every time bu occassionally. Is it a good
> method to run DBCC SHOWCONTIG when the Database is ONLine?
> Thanks in advance
> Anand.
>
>