After moving database from a full version of SQL Server to SQL Express the Blackberry Server Health Test is now getting "Failed to retrieve Performance Counter" error for the SQL counters.
Performance counter names in SQL Express have changed.
1. In the Spotlight on Messaging console, Expand Tests and right click on the Blackberry Server Health Test and select Edit.
2. Click the "BlackBerry 5 Configuration" page and scroll to the bottom of the page under "Performance Counters"
3. Right click on each of the following performance counters and click edit.
SQLServer:Access Methods\Full Scans/sec
SQLServer:Access Methods\Page Splits/sec
SQLServer:Buffer Manager\Buffer cache hit ratio
SQLServer:Databases\Percent Log Used (BesMgmt)
SQLServer:SQL Statistics\Batch Requests/sec
SQLServer:SQL Statistics\SQL Compilations/sec
4. Modify each of the following counter names replacing SQLServer with MSSQL$SQLEXPRESS
For Example "SQLServer:Access Methods\Full Scans/sec" would become "MSSQL$SQLEXPRESS:Access Methods\Full Scans/sec"
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center