Will this trace slow down performance.This is production server.

Thank you

Windows log:

Event Log: Application Event Type: Error Event Source: MSSQLSERVER Event Category: Server Event ID: 18056 Date: 4/2/2011 3:00:04 AM User: Ccc\ccc_YYYY Computer: Database1 Description: The client was unable to...

SQL agent went down and I have to re started.

This is erroe from sql logs:

SQL Server is terminating because of fatal exception e06d7363. This error may be caused by an...

no, for some reasons when run any code and I close query analyzer, get an error message this code was not commit, even if I do select on the table...

Thank you so much,

I fixed

I am sorry, I didn't right this code and I don't know which statment is causing a problem, I will re write the statment after I find out which update...

Which update statment giving me a problem?

Thank you

This is another execution plan

Hi, here is another stored procedure I found with a problem with nested Loop.Can you please help me to identifiy which update statment is wrong.

Thank you so much

I resolved the problem,but not sure for 100%

I ran update statment 2 hours on that table (I thought update was complited) in the query analyzer and tryed to close it...

EventTypeParametersEventInfo

Language Event0 dbcc inputbuffer (139)

I don't know if this is the same process, but the same table from this table is locked.

Thank you

1.SELECT * FROM sys.dm_db_index_operational_stats(dbid, tableid,NULL,NULL,null) AS ddios

There is no tableid in this and incorect parameter value.

This is what I have from SELECT * FROM sys.dm_exec_requests

yes i have one process running

Guys, this table is locked again and I don't know what is locking.

How can I find out?

Thank you