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.

have you checked sql agent error log?

xp_ReadErrorLog 0, 2, NULL, NULL

go

xp_ReadErrorLog 1, 2, NULL, NULL

post the results for this.

forgot to mention scott 's thought is good allocate the growth size that fits your reuirement.

dont reduce it do low as db growth requires lot of resources and time. check...