Hi I'm a junior DBA. I got a mail from sql server it shows deadlock occurred. As a junior I don't know what should I do next? 

The mail contains the following columns:

Process id|DB_Name|procname|waittime|lockMode|trancount|clientapp|hostname|loginname|frame|inputbuf

Anyone please teach me what is next process ?

• Edited by BhuvaneshAadhira 2 hours 13 minutes ago

Hello,

Deadlocks are often caused by bad application and/or database design, so you have to dig deep into.

See:
Detecting and Ending Deadlocks
Analyze Deadlocks with SQL Server Profiler
Minimizing Deadlocks

Thanks Olaf Helper, But my senior said please check index status on objects. Can you please explain what is the necessary to check objects index status? 

I don't know what your senior mean with "index status" here; disabled, fragmentation or ...?