SQL 2012 performance counter name and value appearing in view but not in emailed alert

Question

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:

object_name: MSSQL$SQL2012:Databases 

counter_name:  Data File(s) Size (KB)

instance_name:  _Total   

cntr_value: 2562880 

cntr_type: 65792

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!

 

Answer 1

Hi

A fix has been released for this today as part of SQL Server 2012 CU2 http://support.microsoft.com/kb/2703275 ref: http://support.microsoft.com/kb/2699820

Answer 2

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 PM

DESCRIPTION:   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).