Results 1 to 5 of 5

Thread: Capture SQL Server Healthy

  1. #1
    Join Date
    May 2010
    Posts
    5

    Capture SQL Server Healthy

    Hi all professional.

    When we work with SQL Server, the essential demand is to monitor some parameters on SQL Server, such as CPU, Memory, I/O, Locked Processes, Audit Login, Logout... by capture them interval 1 period of time (ex: 5 minutes) and insert these information into 1 database.

    If we don't use SQL Profiler, how can we get these information? Do we query on database to get these information?

    Please help me on this.

    Thanks so much and Best Regards .

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Many of them are in perfmon, and you can turn on sql login auditing.

  3. #3
    Join Date
    May 2010
    Posts
    5
    Thanks. I know that but if I want to capture them and insert these information into 1 database. The Information from Lots of Server running SQL Server will are gathered to 1 place, and at 1 point of time, I can know the healthy of each server by reporting.

    Can I query from database to get these information?

    Please help me. Thanks so much

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Sql2k8 has that feature builtin, which version do you use?

  5. #5
    Join Date
    May 2010
    Posts
    5
    I'm using SQL Server 2000 and 2005.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •