SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD Books SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » SQL Response from Redgate

SQL Response from Redgate Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Mani
Posted Wednesday, November 19, 2008 5:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 02, 2009 9:14 PM
Points: 186, Visits: 607
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
Post #605492
sqlizer
Posted Wednesday, November 19, 2008 8:32 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 7:43 PM
Points: 569, Visits: 558
....

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
Post #605539
K. Brian Kelley
Posted Wednesday, November 19, 2008 8:39 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Sunday, June 14, 2009 9:31 AM
Points: 6,014, Visits: 1,146
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Contributing Author of How to Cheat at Securing SQL Server 2005 and Pro SQL Server 2008 Administration
| Professional Site | Blog | View Brian Kelley's LinkedIn profile | Twitter
Post #605544
« Prev Topic | Next Topic »


Permissions Expand / Collapse

 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use