Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Manage system performance from SQL2005 Expand / Collapse
Author
Message
Posted Wednesday, September 17, 2008 3:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 3:48 AM
Points: 1, Visits: 23
Hi there!
I'm looking for some way to manage diversal computer couters from the server where I have instaled the SQL Servers.
For example I want that SQL send me some alert when the free space in the logical disk where I have the database it's less that 20%, for example.

I'm used to use performance object -> Logical Disk and the counter -> %Free Sapce, but i want to linked with SQL Server 2005 if it's possible.

Any body could help me?

Thanks in advance
Post #570856
Posted Wednesday, September 17, 2008 4:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 17, 2011 6:18 AM
Points: 32, Visits: 73
Joanpardo71,

If you want to use PERFMOM you can stream the measured counters directly to a table within a database.
Extract it from there to create detailed reports on these counters.

Examine the Dynamic Managed Views -- they contain loads of statistic (realtime) information, not only for SQL server but also from your system SQL is running on.

Hope this will help.

Regards,

GKramer
The Netherlands
Post #570885
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse