-
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 .
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|