Hi Arthur,

Best of Luck,

Regards

Binu John

Thanks Ken,

But hope that I have made the statement against deadlocks and not of normal blocks.

Rgds

Binu John

this seems help me too, thanks in advance

Hi MeenakshiSundaram Lakshmanan,

The trucation of logs depends on different scenario. If the Tr.log is not replicated then that log will not truncate while you take backup.You can also specify to...

Although deadlocks cannot be avoided completely, the number of deadlocks can be minimized. Minimizing deadlocks can increase transaction throughput and reduce system overhead. Dead locks can be redused in following...

Hi De,

Its the time in milliseconds that the cpu has spent working.

Dear mark,

Thanks..a ton

I simply killed that session after knowing that user has quited.

Yes I have also faced the same issue..

This information is not sufficient to help you out.But from the spid given, you can find out the Pid(process Id)from sysprocess(select hostprocess from master..sysprocesses where spid=137). Using the pid you...

Kindly tell me where is DBCC IND in sql server

You can also use sysprocesses system table in query analyser where you can decide which are the fields you want..Like cpu,IO utalization,machine name,spid,loginame etc...

Can anybody help me..

I can not found DBCC IND in Books onlone.Where I can locate it?

Thanks in advance

Use Trace Flag Dbcc trace on(1807)

Hi Mark,

Date field allows nulls but make sure that your front end doesnt pass any default date values