| Author |
Transactions/sec Counter
|
|
| Benjamin Nevarez 2005-04-05, 8:01 pm |
|
Hello All,
I want to store and analyze the information on performance objects/counters
like 'Transactions/sec' and 'Batch Requests/sec'. When I use
Performace/System Monitor it shows values like Average 9.464 but if I run
queries like
select * from sysperfinfo
where object_name = 'SQLServer:Databases
'
and counter_name = 'Transactions/sec'
and instance_name = '_Total'
select * from sysperfinfo
where object_name = 'SQLServer:SQL Statistics'
and counter_name = 'Batch Requests/sec'
then I see values like 16481022. What are these numbers (like 16481022)? How
can I get the 9.464 (shown in System Monitor) from the sysperfinfo table?
Thanks,
Benjamin Nevarez
SQL Server DBA
| |
| Andrew J. Kelly 2005-04-06, 7:01 am |
| Most of the counters in sysperfinfo are cumulative and you must take a delta
to make sense of them.
--
Andrew J. Kelly SQL MVP
"Benjamin Nevarez" < BenjaminNevarez@disc
ussions.microsoft.com> wrote in
message news:1E7529D9-2F30-4A78-999A- 8B2925537DD5@microso
ft.com...
>
> Hello All,
>
> I want to store and analyze the information on performance
> objects/counters
> like 'Transactions/sec' and 'Batch Requests/sec'. When I use
> Performace/System Monitor it shows values like Average 9.464 but if I run
> queries like
>
> select * from sysperfinfo
> where object_name = 'SQLServer:Databases
'
> and counter_name = 'Transactions/sec'
> and instance_name = '_Total'
>
> select * from sysperfinfo
> where object_name = 'SQLServer:SQL Statistics'
> and counter_name = 'Batch Requests/sec'
>
> then I see values like 16481022. What are these numbers (like 16481022)?
> How
> can I get the 9.464 (shown in System Monitor) from the sysperfinfo table?
>
> Thanks,
>
> Benjamin Nevarez
> SQL Server DBA
>
| |
| ChrisR 2005-04-06, 7:01 am |
| Lumigents Log Explorer has a great TPS counter.
"Benjamin Nevarez" < BenjaminNevarez@disc
ussions.microsoft.com> wrote in
message news:1E7529D9-2F30-4A78-999A- 8B2925537DD5@microso
ft.com...
>
> Hello All,
>
> I want to store and analyze the information on performance
> objects/counters
> like 'Transactions/sec' and 'Batch Requests/sec'. When I use
> Performace/System Monitor it shows values like Average 9.464 but if I run
> queries like
>
> select * from sysperfinfo
> where object_name = 'SQLServer:Databases
'
> and counter_name = 'Transactions/sec'
> and instance_name = '_Total'
>
> select * from sysperfinfo
> where object_name = 'SQLServer:SQL Statistics'
> and counter_name = 'Batch Requests/sec'
>
> then I see values like 16481022. What are these numbers (like 16481022)?
> How
> can I get the 9.464 (shown in System Monitor) from the sysperfinfo table?
>
> Thanks,
>
> Benjamin Nevarez
> SQL Server DBA
>
| |
| Benjamin Nevarez 2005-04-06, 8:01 pm |
|
This is interesting. But what is really that number? The number of
transactions since when? Since the server started? Is this documented
somewhere?
Thanks,
Ben
"Andrew J. Kelly" wrote:
> Most of the counters in sysperfinfo are cumulative and you must take a delta
> to make sense of them.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Benjamin Nevarez" < BenjaminNevarez@disc
ussions.microsoft.com> wrote in
> message news:1E7529D9-2F30-4A78-999A- 8B2925537DD5@microso
ft.com...
>
>
>
| |
| Andrew J. Kelly 2005-04-06, 8:01 pm |
| I believe it is since the server was last started. Other than booksonline
for sysperfinfo I don't know if there is anything else. If you don't want
to deal with the deltas then use perfmon.
--
Andrew J. Kelly SQL MVP
"Benjamin Nevarez" < BenjaminNevarez@disc
ussions.microsoft.com> wrote in
message news:0350CCCB-4A07-43FF-A3FB- 57C7F7E52F01@microso
ft.com...[color=darkred]
>
> This is interesting. But what is really that number? The number of
> transactions since when? Since the server started? Is this documented
> somewhere?
>
> Thanks,
>
> Ben
>
> "Andrew J. Kelly" wrote:
>
|
|
|
|