Hi All
We are working on a project for DTW that will attempt to highlight unusual activity within SQL Server and alert you using SQL Monitor. As part of this we are looking to see if we can correlate metrics to give a indication on the root cause of the problem. E.g if X is high, Y is low and Z is running slow it may be that

is the problem. What I like help with is is what sort of problems can be solved via this approach, what would x,y and z be and how do we determine "good/bad" levels? Just looking for a couple of examples that we can use to see if this approach will work.
Happy to do a call with anyone or alternatively yoy can stick your thoughts down in this thread.
many thanks
Mark
We are working on a project for DTW that will attempt to highlight unusual activity within SQL Server and alert you using SQL Monitor. As part of this we are looking to see if we can correlate metrics to give a indication on the root cause of the problem. E.g if X is high, Y is low and Z is running slow it may be that
Happy to do a call with anyone or alternatively yoy can stick your thoughts down in this thread.
many thanks
Mark