frankwang

Thank you very much for such detailed guide.

Hi Mandevil, Our version is 9.2.119,it should be the latest one.Could you suggest how to do,I am new to DPA?

it is SQL2012

Hi All, I have similar issue that PLE down to almost 0 very quickly,but not so frequently than Eric's issue,3~4 times per week.Now I want to setup an alert,that there will be mail notification while the PLE value less than 7200sec,then we can look into it once receive the notification,but not sure how to setup the job,Does…

one more question, is it possible to limit the monitoring scope to schema level in this alert job? like database A has two schemas: schema_a and schema_b , but i only need to monitor blocking performance of schema_a,but ignore to schema_b. Thanks.

Thank you very much!

Hi , We have setup the job and found it is useful (we are running SQL2014) but i have a problem,as this alert is to SQL instance level in configuration,but there is two database(A & B) running on this instance. is there a way to limit this alert to database A only? We do not expect to trigger any alert to database B when…

with Custom SQL Alert - Single Numeric Return,I am trying to use below query,but not sure how to supress the output of 'my query',does this work if supress output of 'my query' works? <span class="kwd" style="color:#00008b;">DECLARE</span><span class="pln" style="color:black;"> </span><span class="pun"…