I have completed the installation and configuration of the EPM Framework and am noticing some inconsistencies in the evaluation of the policies. I have a SQL 2008 standard edition named instance called DEV01 (development #1). Within this instance
I have two databases: DBA and SDE_DEV2 which are configured as follows:
As you can see, these databases are configured virtually the same. I was quite surprised when the dashboard for EPM showed that DBA passes the "Data and Log File Location" policy while SDE_DEV2 fails. I can't include a screenshot but
here's the same information directly from the database.
select evaluationDateTime, EvaluatedPolicy, Evaluatedobject, PolicyResult
where EvaluatedPolicy='Data and Log File Location'
evaluationDateTime EvaluatedPolicy Evaluatedobject PolicyResult
2011-12-06 09:28:28.160 Data and Log File Location SQLSERVER:\SQL\VMDEV-APP2\DEV01\Databases\DBA PASS
2011-12-06 09:28:28.160 Data and Log File Location SQLSERVER:\SQL\VMDEV-APP2\DEV01\Databases\SDE_DEV2 FAIL
Can anyone explain why I'm getting different results between these two DBs? Can anyone explain how to trace through and debug to find the cause?