• What do you mean by 0 Deadlocks...

    According to my MEAN Knowledge, if it is NO (0) deadlocks.. yes it is always possible and Good to have NO Deadlocks...on a SQL Server system.

    This means your system is not highly transactional Or is very well maintained:::: i.e. Database is normalized and All Queries are using proper HINTS and your server settings are optimized.

    Correct me if i am WRONG.

    if you see a deadlock that is in place for a long time, make sure, it is not running a HUGE Query.. then kill the SPID associated with it...

    (Before taking this step.. make sure the SPID is not performing any Data Changes in the DB)