I have been looking at the results from the query below against the sysperfinfo on table on a server running SQL Server 2000 SP3 on Windows 2000 Server SP 4. I am wondering exactly how to interpret these results.According to the documentation, these should represent the value over an interval, but it is fairly obvious that 1,693,549,443 Batch Requests/sec is not possible. I have been searching the web for an explanation of this, but haven’t found anything to make sense of it. I am guessing that I should calculate it this way: cntr_value*.0000001 to get the true value, but that is just a guess. It at least puts the numbers in the same range as what I see when I run Performance Monitor.Another thing I have noticed is that these values do not change as much as what I am seeing when I run Performance Monitor to look at the same values. I have a feeling that they represent averages over a much longer interval that 1 second.I see similar results when I run this against other SQL 2000 servers, so I think the query results are normal.Does anyone have any good information or links about this?select cntr_value, cntr_type, left(rtrim(counter_name),30) as counter_namefrom master.dbo.sysperfinfowhere object_name = 'SQLServer:SQL Statistics'order by counter_nameResults:cntr_value cntr_type counter_name ----------- ----------- ------------------------------13818246 272696320 Auto-Param Attempts/sec1693549443 272696320 Batch Requests/sec4968033 272696320 Failed Auto-Params/sec8275400 272696320 Safe Auto-Params/sec92517551 272696320 SQL Compilations/sec158527 272696320 SQL Re-Compilations/sec574810 272696320 Unsafe Auto-Params/sec(7 row(s) affected)
CODO ERGO SUM
SYSPERFINFO SQLServer:SQL Statistics
Posted - 2009-01-02 : 11:39:42
