I would like to know how to trap performance statistics for connections to a particular SQL Server 7.0 database.
I am looking for info on CPU, rows read, number of connections, duration of connection, and whatever else I can get for each user process attached to a database.
Any info on this type of monitoring would be helpful.
I am trying to trouble-shoot a particular issue that plagues us at 12:00PM every Monday. It is clear that a user has a scheduled query or process, but we can't identify who or what it is..........
Thanks in advance.
Richard M.
I am looking for info on CPU, rows read, number of connections, duration of connection, and whatever else I can get for each user process attached to a database.
Any info on this type of monitoring would be helpful.
I am trying to trouble-shoot a particular issue that plagues us at 12:00PM every Monday. It is clear that a user has a scheduled query or process, but we can't identify who or what it is..........
Thanks in advance.
Richard M.