Monday, June 18, 2012 11:10 PM
Installed SQL Server 2012 Standard 32-bit RTM on my 32-bit Windows 7 Enterprise desktop PC with 4 GB of memory, as a named instance. I'm in the process of performing a test install in preparation for upgrading our development SQL Server. Everything going fine so far, database files copied, databases restored and upgraded from 2008, database mail enabled, etc.
This query: select * from sys.dm_os_performance_counters order by counter_name
produces a list of counters with cntr_value looking reasonable. Specifically, here is the total data file size counter:
counter_name: Data File(s) Size (KB)
However when I create a performance alert, the email I receive looks like this, even though I have checked the box "Replace tokens for all job responses to alerts" pertaining to SQL Server Agent Properties--Alert System.
DATE/TIME: 6/18/2012 2:50:53 PM
DESCRIPTION: The SQL Server performance counter 's' (instance 's') of object 's' is now above the threshold of s (the current value is s).
Unfortunately 's' doesn't cut it, I need an actual number. Thanks for your help!
Tuesday, June 19, 2012 7:28 AM
- Marked As Answer by Nicole Garris Tuesday, June 19, 2012 8:59 PM
Tuesday, June 19, 2012 8:58 PM
Thank you. I downloaded and applied SQL Server 2012 CU 2 and now the email alert reads (as it should):
DATE/TIME: 6/19/2012 1:56:33 PMDESCRIPTION: The SQL Server performance counter 'Data File(s) Size (KB)' (instance '_Total') of object 'Databases' is now above the threshold of 0.00 (the current value is 2565888.00).