New posts in Sql Tuning

need to tune this sql query to improve performance

How to find out why the status of a spid is suspended? What resources the spid is waiting for?