HI ,

Its not possible to find the performance issue in single shot . We need to analyze what are the reasons for this issue [from App, Db ,net work]...

HI Smith ,

Can you please go through the below links , it might help full to you .

http://sqlserverpedia.com/blog/sql-server-2005/i-had-a-question-regarding-page-life-expectancy-in-sql-server-2005-what-causes-page-life-expectancy-to-be-very-low-if-you-have-low-page-life-expectancy-how-is-it-resolved-and-avoided/

http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-what-is-page-life-expectancy-ple-counter/

http://msdn.microsoft.com/en-us/library/ms177455%28v=SQL.90%29.aspx

Thanks ,

HI Pallavi,

Can you please go through the below links :

http://support.microsoft.com/kb/918992/

http://support.microsoft.com/kb/246133/

http://www.techrepublic.com/blog/howdoi/how-do-i-transfer-logins-from-one-sql-server-2005-instance-to-another/140

Thanks

Lavanya

HI Dev,

Is there any possibility to find the size of the MSDTC log file , how much free space is available ??

Can you please confirm once we restart the MSDTC...

HI ,

I found the below error from Windows lOg

The maximum number of active transactions that the MS DTC log file can accomodate has been exceeded. You must increase the...

HI Dev,

I am providing the error no :

Error no : Message

Error: 8510, Severity: 20, State: 3.

Message

Enlist operation failed: 0x8004d01c(error not found). SQL Server could not register with Microsoft...

HI dev,

The first solution is we changed to transaction timeout to '0'.

Recently i changed the log file size to 150 MB from default size .

Again we...

Dev (12/8/2011)

---

Before I ask anything related to issue, one general question...

You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I believe...

HI dev,

which inputs you want from my side ??

HI Team ,

From the error log found the below ::

1.Distributed Transaction Coordinator service terminated unexpectedly

2.Enlist operation failed: 0x8004d01c(error not found). SQL Server could not register with Microsoft Distributed...

HI,

No need to restart the SQL server .

HI ,

I did the same as you mentioned but i am seeing same error .

Kill 154

next

kill 154 WITH STATUSONLY

May i know why these type of...

HI, when i try to kill the process with status only i am getting below error

[KILL 158 WITH STATUSONLY]

Msg 6120, Level 16, State 1, Line 1

Status report cannot...

HI Seth,

-2 is DTC orphan transaction to kill this ,you have to first find UOW( unit of work) from sys.dm_tran_locks --

why its happening ?? its code related issue...

HI Seth,

Thanks for the update. Now we are not seeing this error now because we restart the server.

after restart of the server we are seeing the below issue.

...