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