• Contact
  • Cookie Policy
  • Helpdesk
Techspark Blogging about technical stuff

Category Archives: Operations Manager

Operations Manager 2012 R2 – Data Warehouse can’t process performance data

February 4, 2014 4:26 PM / Leave a Comment / XeroX

We had the problem that our data warehouse can’t process all performance data being collected. To get rid of this problem you need to disable some performance collection rules in your opsmgr 2012r2 (preferable the ones you don’t need).

You may find out which one collect most data you can run the following queries against your dwh.

Performance insertions per day

SELECT CASE WHEN(GROUPING(CONVERT(VARCHAR(20), TimeSampled, 102)) = 1)
THEN ‘All Days’ ELSE CONVERT(VARCHAR(20), TimeSampled, 102)
END AS DaySampled, COUNT(*) AS PerfInsertPerDay
FROM PerformanceDataAllView with (NOLOCK)
GROUP BY CONVERT(VARCHAR(20), TimeSampled, 102) WITH ROLLUP
ORDER BY DaySampled DESC

To find the rules collecting the most Performance Signature data in the database

select managementpack.MPName, ruleview.DisplayName,
count(*) AS TotalPerfSig
from performancesignaturedata with (nolock)
inner join performancesignaturehistory with (nolock)
on performancesignaturedata.performancesignaturehistoryid = performancesignaturehistory.performancesignaturehistoryid
inner join performancesignature with (nolock)
on performancesignaturehistory.performancesignatureid = performancesignature.performancesignatureid
inner join ruleview with (nolock)
on ruleview.id = performancesignature.learningruleid
inner join managementpack with(nolock)
on ruleview.managementpackid = managementpack.managementpackid
group by managementpack.mpname, ruleview.Displayname
order by TotalPerfSig DESC, managementpack.mpname, ruleview.DisplayName

Good luck

Posted in: Microsoft, Operations Manager / Tagged: Data Warehouse, OpsMgr, Performance, SCOM, SCOM 2012R2, SCOM2012

Recent Posts

  • Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense
  • Recover ESXi 7.x Bootbank
  • Microsoft Edge URI List – Open Office Apps without Prompt for SharePoint
  • Boot Batocera from HDD/SSD
  • Synology iSCSI/LUN SSD Cache with DSM 7.0

Recent Comments

  • XeroX on Synology Virtual Machine Manager increase vDisk Limit
  • Yann@Paris on Synology Virtual Machine Manager increase vDisk Limit
  • XeroX on Boot Batocera from HDD/SSD
  • Dom on Boot Batocera from HDD/SSD
  • XeroX on Boot Batocera from HDD/SSD

Archives

  • February 2023
  • November 2022
  • September 2022
  • September 2021
  • August 2021
  • November 2020
  • November 2015
  • June 2015
  • February 2015
  • August 2014
  • June 2014
  • March 2014
  • February 2014
  • January 2014
  • November 2013
  • September 2013
  • August 2013

Categories

  • ESXi
  • FreeBSD
  • Hardware
  • Hyper-V
  • iOS
  • Microsoft
  • OfficeWebApps
  • Operations Manager
  • SharePoint
  • Synology
  • vCenter
  • VMWare
  • Webserver
  • Windows Server
© Copyright 2023 - Techspark
Infinity Theme by DesignCoral / WordPress