BUG: sysperfinfo counters are not time-adjusted

Article translations Article translations
Article ID: 555064 - View products that this article applies to.
Author: Geoff Hiten MVP
Expand all | Collapse all

SUMMARY

Selecting counters from the sysperfinfo virtual table gives raw values for per-second counters.

SYMPTOMS

Selecting any time-based counter from sysperfinfo will give raw counters, not time adjusted counters.  The column_name field indicates a time-adjusted value but the cntr_value field returns a raw, monotonically increasing value.  This applies to SQL alert engine queries as well as user queries.  As such, alerts on per-second values are not possible.

MORE INFORMATION

All of the following values of counter-name are affected:
Auto-Param Attempts/sec                                                                                                        
AWE lookup maps/sec                                                                                                            
AWE stolen maps/sec                                                                                                            
AWE unmap calls/sec                                                                                                            
AWE unmap pages/sec                                                                                                            
AWE write maps/sec                                                                                                             
Backup/Restore Throughput/sec                                                                                                  
Batch Requests/sec                                                                                                             
Bulk Copy Rows/sec                                                                                                             
Bulk Copy Throughput/sec                                                                                                       
Cache Use Counts/sec                                                                                                           
Checkpoint pages/sec                                                                                                           
DBCC Logical Scan Bytes/sec                                                                                                    
Extent Deallocations/sec                                                                                                       
Extents Allocated/sec                                                                                                          
Failed Auto-Params/sec                                                                                                         
Forwarded Records/sec                                                                                                          
Free list empty/sec                                                                                                            
Free list requests/sec                                                                                                         
Free list stalls/sec                                                                                                           
FreeSpace Page Fetches/sec                                                                                                     
FreeSpace Scans/sec                                                                                                            
Full Scans/sec                                                                                                                 
Index Searches/sec                                                                                                             
Latch Waits/sec                                                                                                                
Lazy writes/sec                                                                                                                
Lock Requests/sec                                                                                                              
Lock Timeouts/sec                                                                                                              
Lock Waits/sec                                                                                                                 
Log Bytes Flushed/sec                                                                                                          
Log Cache Reads/sec                                                                                                            
Log Flush Waits/sec                                                                                                            
Log Flushes/sec                                                                                                                
Logins/sec                                                                                                                     
Logouts/sec                                                                                                                    
Mixed page allocations/sec                                                                                                     
Number of Deadlocks/sec                                                                                                        
Page Deallocations/sec                                                                                                         
Page lookups/sec                                                                                                               
Page reads/sec                                                                                                                 
Page Splits/sec                                                                                                                
Page writes/sec                                                                                                                
Pages Allocated/sec                                                                                                            
Probe Scans/sec                                                                                                                
Range Scans/sec                                                                                                                
Readahead pages/sec                                                                                                            
Safe Auto-Params/sec                                                                                                           
Scan Point Revalidations/sec                                                                                                   
Shrink Data Movement Bytes/sec                                                                                                 
Skipped Ghosted Records/sec                                                                                                    
SQL Compilations/sec                                                                                                           
SQL Re-Compilations/sec                                                                                                        
Table Lock Escalations/sec                                                                                                     
Transactions/sec                                                                                                               
Unsafe Auto-Params/sec                                                                                                         
Workfiles Created/sec                                                                                                          
Worktables Created/sec                                                                                                         

Properties

Article ID: 555064 - Last Review: February 25, 2004 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbpubmvp kbpubtypecca kbhowto KB555064
COMMUNITY SOLUTIONS CONTENT DISCLAIMER
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com