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.:rolleyes:

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

Please help me on this.

Thanks so much and Best Regards :).

Many of them are in perfmon, and you can turn on sql login auditing.

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:)

Sql2k8 has that feature builtin, which version do you use?

I'm using SQL Server 2000 and 2005.