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.
Selecting counters from the sysperfinfo virtual table gives raw values for per-second counters.
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.
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