FAQShop.com : Can I Use MOM to Monitor the Response Time of a SQL Statement?

Can I Use MOM to Monitor the Response Time of a SQL Statement?

Could I use MOM to monitor the response time of a SQL statement and generate a report on the number of requests for this statement and the response time of each?

Contributed By: Baelson Duque [MSFT]
From our SQL MP PM:

==
Yes..but they will need to write a script using DMO to do this. We do not have anything which does this at present.

In the next version of the MP, we have a client side monitoring capability which you can set a time in which the script must execute or an alert is raised. You could then write a report around this.