Please let me know the table which extracts the metrics data of SQL application. i want to query that using API call.These are the metrics i am looking to extract.
Do we have separate database tables for separate applications. i,e.,. for ex: web sphere, Oracle ,SharePoint applications.
The buffer cache-hit ratio
Lazy Writes/Second
Lock wait time(ms)
Local Waits/Second
Login/Second
Page life expectancy
Page Read/Second
Page Write/Second
Sqlserver Service
User Connections
Event ID 208(Sqlagent Job failure),
Check DB Alive
