November 19, 2008 at 5:41 pm
Hi,
Iam recently startedusing SQL Response to monitor SQL Servers.
Here are some questions regaridng sql response:
Can we monitor other than the below?
1.Data file has excessive free space
2.Fragmented index
3.Full backup overdue
4Log backup overdue
5.Integrity check overdue
6.no backup exists for database
7.page verification is off
8.Transaction log has excessive free space
Because I would like to monitor the following, But I did not find any options to choose from sql response. If we can monitor plz advice how to do that.
1.Dead locks
2.CPU usage
3.Disk Space
4.cashe hit ratio
5.Long running queries
6.No of users and connections and process.
thanks
November 19, 2008 at 8:32 pm
....
Because I would like to monitor the following, But I did not find any options to choose from sql response. If we can monitor plz advice how to do that.
1.Dead locks
2.CPU usage
3.Disk Space
4.cashe hit ratio
5.Long running queries
6.No of users and connections and process.
thanks
1.Dead locks: SQL Server Profiler
2.CPU usage: Performance Monitor
3.Disk Space:
4.cashe hit ratio: Performance Monitor
5.Long running queries : SQL Server Profiler
6.No of users and connections and process : SQL Server Profiler
November 19, 2008 at 8:39 pm
I know for sure it monitors the following:
- Deadlocks
- CPU Usage
- Disk Space
- Long Running Queries
I saw those during the review process I did. I know it captures usage and processes if it flags an event, but I didn't see that separately. I don't think it monitored cache hit ratio. You might be better served, though, posting on the Red Gate forum specifically for SQL Response.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply