sys.dm_os_performance_counters | SQL Server Performance Forums

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=’:D‘ />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.
quote:Originally posted by satya 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.

]]>