• Sapen,

    I recommend using this for that:

    SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)

    Chapter 2 specifically.

    One key thing is that the thresholds are best determined by comparing to a baseline you create. The baseline being what metrics look like under normal operating conditions (when things are going smooth).