Problems running on SQL 2008 R2

Aug 20, 2010 at 3:45 PM

Hello,

I don't seem to be getting data moved over into the mdw_control database when I stop collecting. I looked at the two stored procedures that get installed into mdw_control, and these reference a table "snapshots.performance_counters" that doesn't exist in the MDW database. There is a snapshots.performance_counter_instances, and snapshots.performance_counter_values, but these don't match the scheme exactly of the other referenced tables. Is there something that changed in R2 that breaks these, or were they never working for 2008 in the first place?

Thanks,

Jayme

Dec 15, 2010 at 1:20 PM

I addet a new item to the isue tracker and now I see: you have the same problem reported 4 month ago. You have to change the procedure: http://sqlsrvanalysissrvcs.codeplex.com/workitem/14885