RE: Blocked Process

RE: Blocked Process

 

  

Hi Thomas,

Basicaslly we did a data center migration 2 months ago but since that we
have so many memory issues. And now the blocking issues.

Thanks

-----Original Message-----
From: Thomas Andre L.
[mailto:mssqldba-ezmlmshield-x36291054.[Email address protected]
Sent: 31 August 2007 02:14 PM
To: LazyDBA Discussion
Subject: RE: Blocked Process


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.






---------------------------------------------------------------------
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

MS Sql Server LazyDBA home page