SQL Server Performance Forum – Threads Archive

sys.dm_os_performance_counters

To make use of the counter value returned when running sys.dm_os_performance_counters, looking at Object_Name = SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />atabases and Counter_Name = Transactions/Sec (according to BOL this value is cumulative), would you:<br /><br />Step 1: Take two different readings and get the difference between the two counter values.<br /><br />Step 2: Obtain the number of seconds that transpired between the two different readings of counter values in Step 1.<br /><br />Step 3: Divide the value obtained in Step 1 by the value obtained in Step 2, to obtain the number of Transactions/Sec that occurred during that time frame.<br /><br />Is that correct?

---

Yes in general to obtain the transaction performance in this case, BTW what you want to achieve with this calculations. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

Thanks Satya.
I am looking to obtain some ongoing performance baseline information.

---

]]>