Online process cause application to slow/hang

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bry <fqies_bry@xxxxxxxxx>
Date: Mon, 27 Aug 2007 19:43:25 -0700

Hi,

I would like to ask what could be the cause why our application get
performance issues like slowness/hang when we perform online process/
maintenance like DBCC Indexdefrag and DBCC SHRINKFile? Is there
configuration in SQL that may cause this? the database size is around
500 to 600GB.

Also, I scheduled a job to shrink the data file around 11PM, then a
backup to tape ran around 1AM of the next day, the application become
slow, does this two processes might cause the performance issue?

Is the DBCC ShrinkFile can locked the whole database?

Thanks.

.

Follow-Ups:
- Re: Online process cause application to slow/hang
  - From: Tibor Karaszi

Prev by Date: Re: unexpected failure during the setup - help!
Next by Date: How to Set Instance Name and SECURITYMODE/SA/Password in VS2005 Setup project (Prerequisites SQL Server 2005 express)
Previous by thread: Manually create database with existing mdf file gives Cannot create file because it already exists
Next by thread: Re: Online process cause application to slow/hang
Index(es):
- Date
- Thread

Relevant Pages

Re: Disaster freeing space in 200GB database
... Run DBCC UPDATEUSAGE to make sure you are seeing accurate information. ... DBCC SHRINKFILE since it gives me a finer degree of control. ... Senior Database Administrator ... data file increased by the amount of data deleted. ...
(microsoft.public.sqlserver.server)
Re: Protokolle werden nicht gekürzt
... oder Transaction Log Sicherungen vorgesehen sind, ... DBCC SHRINKFILE and DBCC SHRINKDATABASE are not logged ... either the DBCC SHRINKFILE or the DBCC SHRINKDATABASE commands. ...
(microsoft.public.de.sqlserver)
Re: How do I shrink my logfile?
... I followed the instructions in the link but when I run DBCC ... checked sysfiles and, true, it is not there. ... Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE ... I set my database option to AutoShrink. ...
(microsoft.public.sqlserver.server)
Re: Datenbank verkleinern
... dass das Transaction Log sehr ... Ein testweise ausgeführtes DBCC SHRINKFILE ... Den gleichen Fehler erhalte ich bei allen anderen DBs ...
(microsoft.public.de.sqlserver)
Re: release database unused space
... (DBCC DBREINDEX or DBCC INDEXDEFRAG.) ... "Daniel" wrote in message ... > I have deleted 100K records from a table in a database. ... I ran the DBCC shrinkfile & DBCC shrinkdatabase to ...
(microsoft.public.sqlserver.server)