I'm running into an issue while trying to create a rule. I'm simply
trying to add a performance rule to capture a performance monitor
counter from my SQL Server machines. Specifically I want to see the
cache hit ratio for stored procedures. Here is what I tried to create:
object: $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/
PerformanceCounterObject$:Cache
Counter: Cache Hit Ratio
Instance: Procedure Plans
After searching through the groups, I tried changing the object
reference by adding /Host after the $Target, but I got the same error.
Any help at all here would be appreciated.
Here's the error:
Date: 3/28/2008 11:29:55 AM
Application: System Center Operations Manager 2007
Application Version: 6.0.6246.0
Severity: Error
Message:
: Processing the template failed. See inner exception for details.
Verification failed with [1] errors:
-------------------------------------------------------
Error 1:
: Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
-------------------------------------------------------
Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Verification failed with [1] errors:
-------------------------------------------------------
Error 1:
: Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
-------------------------------------------------------
Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Failed to verify referenced module : ID=DS
Invalid configuration specified for Module [DS]Cannot resolve
identifier [SQL!Microsoft.SQLServer.DBEngine] in the context of
ManagementPack [FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Invalid configuration specified for Module [DS]
Cannot resolve identifier [SQL!Microsoft.SQLServer.DBEngine] in the
context of ManagementPack [FMG.SQL.Management.Pack]. Unknown alias
[SQL]
: Cannot resolve identifier [SQL!Microsoft.SQLServer.DBEngine] in the
context of ManagementPack [FMG.SQL.Management.Pack]. Unknown alias
[SQL]
Check the Manifest/References section of your MP to see if "SQL" is the
alias for Microsoft.SQLServer.Library.
"Grant Fritchey" <gran...@gmail.com> wrote in message
news:d9416615-33ad-4c91...@a22g2000hsc.googlegroups.com...
On Apr 2, 12:19 pm, "Mike E" <sentryboy_no_s...@hotmail.com> wrote:
> The problem is with your SQL! reference.
>
> Check the Manifest/References section of your MP to see if "SQL" is the
> alias for Microsoft.SQLServer.Library.
>
> "Grant Fritchey" <grant...@gmail.com> wrote in message
> > [SQL]- Hide quoted text -
>
> - Show quoted text -