do you have more details or document on req_transactionUOW relates..

Hello Antony,

when this is specified : LSN : (250855:13949:24)

is it not a backup related session?

then in that case do we have to check the orginating server/

remove this condition and try

WHERE s.spid > 50

can you post the top 10 result with login time order...

try this i use this to see any block or not.

SELECT

s.spid, login_time, status,case when blocked = '0' then...

thanks both

is there a way to split it when exceeds some size or else we have to use only no of file in configuration?

thanks and i'll read what you have given and comback incase needed.

i mean when a db is restored it should have fresh dmv data be it on same server or different.

Antony,

we have 2 servers one server is updating some data into another.

within SET XACT_ABORT on and off.

after this job added we have tremendous increase in log file growth with just...

i too want to know this...

DMV and data are different.

Data will be definitely the same , hope the dmv data will differ based on server and db.

compare the different collation data bases using

string1 = string2 collate [string1 colaltion]

suresh what r u suspecting, is it another sql instance is running?

if it has another instance...

check this link

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/5c9ee9e2-18a9-4202-9e96-b42dacdaf30a

Hello,

i am not expert in clustering but still can you post the problem in details like services not starting or not pinging something more in details.