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 .