APIs for monitoring MS-SQL

[sotriur]

hi,
i want to retrive the information from MS SQL such as
o Active transactions
o Average wait time for lock requests
o Logical Scan – bytes/second
o Full Scans/Second
o Lock Blocks
o Lock Timeouts/second
o Log Cache Reads/second
o Log Truncations
o Logins/second
o SQL Agent\Failed SQL Agent Jobs
o SQL Server Backups\Failed SQL Backups
o SQL Server Replication\Merge\Conflicts/second.

i am searching for API for doing the above said function.
can anyone help me.
thanks in advance

[iburyak]

Not sure if API like this exists but you can definitely use system tables to get all necessary information.

Some of which you can pool using query like this:

[PHP]select spid, blocked, loginame,hostname, program_name,a.status,
login_time, last_batch, lastwaittype, b.name db_name, waittime/100 waittime
from master..sysprocesses a
join master..sysdatabases b on a.dbid = b.dbid [/PHP]