First thing to do is to define what's acceptable and what's not acceptable otherwise how would you know there is any degradation?Quote:
Originally Posted by GladiatoR
Set performance baselines for the most critical queries and processes; if possible negotiate performance SLAs with Business then keep the database performing in between the acceptable boundaries.