none
SQL Server Utility : All instances show "No data available" RRS feed

  • Question

  • Hi,

    I have configured a Utility Control Point on my production server and enrolled the other servers as managed instances. After a few days, in the "Utility Explorer" all the instances are in the "No Data Available" group and I can't see any data about CPU utilization, etc.

    BUT, the sysutility_mdm database have grown substancially and when I right-click on it and go to the Reports \ Management Datawarehouse Overview, I can access the reports and drill-down the information without problem.

    What's the problem with my installation?

    Thanks a lot,

    Jean-Michel

    mercredi 1 février 2012 20:26

Réponses

  • At last! I found the solution by reviewing the SQL Agent Jobs and found that the "sysutility_get_views_data_into_cache_tables" job was failing with the error "Snapshot isolation transaction failed accessing database 'DBA_UTI_PRD_01' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation.". I enabled it for that database and reran the job... SUCCESS!

    I don't understand though why this particular database needed snapshot isolation while all the other except master didn't have it. Maybe because I have a DDL audit going on that logs in that database, I checked the job and it doen't seem to do any DDL modifications.

    Anyway, if I find out, I'll post it here, in the meentime, it works.

    Hope it helps someone else since the doc on the sysutility for the moment is rare.

    Jim


    Jean-Michel

    mardi 7 février 2012 14:30

Toutes les réponses

  • At last! I found the solution by reviewing the SQL Agent Jobs and found that the "sysutility_get_views_data_into_cache_tables" job was failing with the error "Snapshot isolation transaction failed accessing database 'DBA_UTI_PRD_01' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation.". I enabled it for that database and reran the job... SUCCESS!

    I don't understand though why this particular database needed snapshot isolation while all the other except master didn't have it. Maybe because I have a DDL audit going on that logs in that database, I checked the job and it doen't seem to do any DDL modifications.

    Anyway, if I find out, I'll post it here, in the meentime, it works.

    Hope it helps someone else since the doc on the sysutility for the moment is rare.

    Jim


    Jean-Michel

    mardi 7 février 2012 14:30
  • Bonjour,

    Vu que le nombre des questions en anglaise sur les forums  TechNet France a grandi je voudrais vous demander nous donner des détails sur la raison pour laquelle vous n’avez pas posté votre question en français. On veut déterminer s’il y a un problème avec notre plateforme ou comment on peut prévenir ce type de problèmes. Merci d’avance de votre collaboration !

    Cordialement,

    Florin



    Florin CIUCA, MSFT       Join TechNetFr on Viadeo   Votez! Appel à la contribution
    Nous vous prions de considérer que dans le cadre de ce forum on n’offre pas de support technique et aucune garantie de la part de Microsoft ne peut être offerte.

    mardi 7 février 2012 19:36
  • Bonjour Florin,

    Je n'y ai même pas songé, c'est par habitude que j'ai écrit en anglais sur le forum parce que la plupart des forums que je consulte sont généralement en anglais. Veuillez m'en excuser.

    Jean-Michel


    Jean-Michel

    mardi 7 février 2012 19:47