1. Check for poorly written queries
2. Fragmentation issues
3. Bottles necks
4. Has any thing changed or changes applied in the database.

-----Original Message-----
From: Henry Bukasa
[mailto:mssqldba-ezmlmshield-x47026983.[Email address protected]
Sent: Thursday, August 30, 2007 4:44 PM
To: LazyDBA Discussion
Subject: Blocked Process

Hi Guys,



I'm getting some of my processes blocking each other. This is happening
now
every day. Is there anything

I can do to end this? We are on MS SQL Server 2000 SP4.



Thanks

Henry Bukasa





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**************************EMAIL DISCLAIMER***************************

This email and any files transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient or the individual
responsible for delivering the e-mail to the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be
taken in reliance on it, is strictly prohibited. If you have received this
e-mail in error, please delete it and notify the sender or contact Health
Information Management 312.413.4947.





MS Sql Server LazyDBA home page