Manage system performance from SQL2005

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply