SQL Server Performance Forum – Threads Archive

performance monitor results

could someone help me to capture online performance monitor statistics using sql queries without using sysmon tool. any script will help a lot.
thanks in advance.

---

You can use: select * from sysperfinfo Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

A valid reference abouthttp://www.databasejournal.com/features/mssql/article.php/3427231 what LUis recommended. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>