sorry. What I am looking for is what conditions should be looked at and have alerts on in SQL Server. Have started with buffer cache hit ratio, blocking locks and...

Dave,

  thanks for that. will give it a run.

Mark