%3CLINGO-SUB%20id%3D%22lingo-sub-1592849%22%20slang%3D%22en-US%22%3EEnhancements%20made%20in%20SCOM%20Performance%3A%20Faster%20and%20more%20reliable%20web%20and%20ops%20consoles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592849%22%20slang%3D%22en-US%22%3E%3CP%3ESCOM%20performance%20has%20been%20one%20of%20the%20top%20user%20voice%20items%20over%20the%20years.%20It%20directly%20impacts%20the%20way%20our%20customers%20interact%20with%20SCOM%20including%20web%20console%20and%20operations%20console.%20%3CBR%20%2F%3EThis%20blog%20aims%20to%20highlight%20specific%20user%20scenarios%20which%20we%E2%80%99ve%20addressed%20in%20SCOM%202019%20release%20and%20also%20the%20ones%20we%20intend%20to%20address%20in%20subsequent%20SCOM%20releases.%20Such%20user%20scenarios%20have%20been%20highlighted%20by%20our%20customers%20which%20is%20reflected%20in%20the%20SCOM%20performance%20issues%20that%20our%20customer%20support%20team%20resolves%20frequently.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EIn%20SCOM%202019%2C%20here%20are%20some%20of%20the%20scenarios%20that%20have%20been%20fixed%3A%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3E1.%20Windows%20computer%20view%20in%20SCOM%20console%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EA%20few%20of%20our%20customers%20gave%20us%20the%20feedback%20that%20opening%20the%20Windows%20computer%20view%20in%20the%20SCOM%20console%20took%20an%20unreasonable%20amount%20of%20time.%20As%20an%20example%2C%20one%20of%20our%20customers%20with%201600%2B%20windows%20computers%20reported%20this%20issue.%20About%201400%20servers%20and%2050%20clients%20(engineers)%20were%20affected%20because%20of%20this%20issue.%20While%20on%20an%20average%2C%20it%20took%20about%208-10%20minutes%20for%20this%20view%20to%20load%2C%20in%20the%20extreme%20cases%20it%20took%20more%20than%2020%20minutes.%20%3CBR%20%2F%3EGiven%20our%20customers%20are%20dependent%20on%20SCOM%20to%20provide%20timely%20information%20including%20but%20not%20limited%20to%20alerts%2C%20health%20and%20performance%20metrics%20of%20their%20applications%20and%20workloads%2C%20the%20performance%20of%20SCOM%20console%20is%20critical%20for%20customers%E2%80%99%20monitoring%20experience.%20To%20decrease%20the%20load%20time%20for%20this%20view%2C%20we%20optimized%20the%20SQL%20query%20relevant%20to%20this%20view.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3E2.%20Changing%20the%20settings%20of%20a%20User%20Role%3C%2FSTRONG%3E%3CBR%20%2F%3EOne%20of%20our%20customer%20had%20an%20environment%20with%20a%20lot%20of%20user%20roles%2C%20views%2C%20classes%20and%20relationship%20types%20in%20the%20database.%20The%20customer%20reached%20out%20to%20System%20Center%20team%20and%20explained%20that%20on%20an%20average%2C%20changing%20the%20settings%20of%20a%20user%20role%2C%20for%20instance%2C%20providing%20or%20revoking%20permissions%20on%20specific%20views%20or%20dashboards%20to%20a%20specific%20user%20role%2C%20took%20about%2030minutes.%20%3CBR%20%2F%3EFurther%20research%20suggested%20that%20many%20other%20SCOM%20customers%20with%20similar%20environment%20also%20experience%20similar%20problem.%20In%20fact%2C%20many%20customers%20concurred%20that%20changing%20setting%20of%2C%20say%2C%2015-20%20user%20roles%20took%20an%20entire%20day%20that%20impacted%20their%20productivity%20and%20ability%20to%20use%20SCOM%20console%20effectively.%20At%20a%20high%20level%2C%20the%20SQL%20queries%20that%20fetched%20relevant%20data%20and%20eventually%20helped%20change%20the%20settings%20of%20a%20user%20role%20was%20optimized.%20This%20optimization%20led%20to%20significant%20improvements%20in%20the%20load%20time%20for%20our%20customers.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3E3.%20Grooming%20of%20Maintenance%20Mode%20Staging%20Table%3C%2FSTRONG%3E%3CBR%20%2F%3EOur%20customer%20support%20team%20received%20a%20case%20from%20our%20customer%20that%20SCOM%20Operations%20Manager%20Datawarehouse%20grooming%20(emptying)%20of%20maintenance%20mode%20staging%20table%20was%20not%20occurring.%20This%20essentially%20meant%20that%20the%20table%20grew%20every%20day%20into%20millions%20of%20rows%20which%20eventually%20filled%20up%20the%20database%20that%20could%20potentially%20lead%20to%20additional%20cost%20to%20the%20customer%20to%20spin%20up%20a%20new%20database.%20%3CBR%20%2F%3EFurthermore%2C%20the%20increase%20in%20utilization%20of%20database%20is%20usually%20correlated%20with%20decrease%20in%20performance%20of%20SCOM%20console.%20To%20fix%20this%20issue%20we%20added%20an%20index%20to%20the%20maintenance%20mode%20stable%20table.%20This%20ensured%20that%20proper%20grooming%20of%20the%20table%20happened.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E4.%20SDK%20service%20not%20starting%20and%20severe%20perf%20degradation%20leading%20to%20SCOM%20console%20not%20loading%3C%2FSTRONG%3E%3CBR%20%2F%3EWhile%20the%20technical%20details%20of%20the%20above%20mentioned%20issues%20are%20beyond%20the%20scope%20of%20this%20blog%2C%20suffice%20to%20say%20that%20a%20couple%20of%20SQL%20queries%20running%20in%20the%20backend%20were%20causing%20the%20above%20mentioned%20issues.%20In%20fact%2C%20a%20few%20our%20customers%20mentioned%20that%20they%20faced%20severe%20performance%20degradation%20since%20they%20upgraded%20from%20SCOM%201807%20to%202019.%20The%20SCOM%20console%20took%20a%20long%20time%20to%20load%20and%20when%20it%20did%20even%20the%20basic%20tasks%20such%20as%20adding%20a%20management%20server%20to%20management%20group%20couldn%E2%80%99t%20be%20completed.%20To%20fix%20this%20issue%2C%20we%20optimized%20the%20SQL%20queries%20relevant%20to%20these%20issues%20which%20lead%20to%20significant%20performance%20improvement.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3E5.%20Reliability%20and%20performance%20improvement%20in%20XPlat%20agent%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EPrior%20to%202019%2C%20monitoring%20data%20related%20to%20health%20and%20performance%20were%20fetched%20through%20requests%20running%20in%20the%20same%20thread%20in%20the%20back%20end.%20Due%20to%20this%20design%2C%20any%20flaws%20in%20the%20perf%20channel%20affected%20the%20heartbeat%20requests%20and%20vice%20versa.%20This%20often%20led%20to%20system%20going%20into%20greyed%20out%20state.%3C%2FP%3E%0A%3CP%3EIn%202019%2C%20we%20isolated%20heartbeat%20threads%20from%20performance%20data%20related%20threads%20which%20meant%20that%20any%20malfunctioning%20in%20performance%20providers%20would%20not%20affect%20heartbeat%20request%2C%20thereby%20improving%20reliability%20of%20SCOM.%3C%2FP%3E%0A%3CP%3EWe%20also%20introduced%20filters%20in%20XPlat%20MPs%20to%20help%20customers%20in%20customizing%20their%20discovery%20and%20monitoring%20scope%20to%20entities%20of%20interest.%20With%20this%20filter%2C%20customers%20can%20define%20OMI%20queries%20to%20limit%20their%20workloads.%20For%20instance%2C%20in%20the%20SuSE%20platform%20there%20is%20a%20file%20system%20called%20%E2%80%9CRaiserFS%E2%80%9D%20which%20is%20not%20supported%20in%20core%20XPlat%20MPs%2C%20yet%20this%20file%20system%20was%20discovered%20with%20inappropriate%20performance%20data.%20Similarly%2C%20in%20case%20of%20hypervisor%20and%20container%20environments%2C%20large%20set%20of%20logical%20entities%20are%20created%20which%20should%20not%20monitored.%20This%20happens%20because%20of%20generic%20nature%20of%20XPlat%20agent%20which%20discovers%20all%20these%20entities.%20With%20the%20introduction%20of%20filters%20in%20Xplat%20MPs%2C%20discover%20and%20monitoring%20of%20all%20such%20entities%20can%20be%20fine-tuned%20further%20to%20improve%20performance%20and%20scale%20of%20XPlat%20agent.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20faced%20above%20mentioned%20issues%20in%20your%20SCOM%20environment%2C%20please%20let%20us%20know%20your%20current%20experience.%20Many%20of%20our%20customers%20are%20still%20using%20SCOM%202012%20and%20SCOM%202016.%20Given%20that%20we%20will%20continue%20to%20make%20significant%20investment%20into%20improving%20SCOM%20performance%20in%202020%2C%20%3CSTRONG%3Ewe%20strongly%20recommend%20that%20you%20upgrade%20your%20environment%20to%20the%20SCOM%202019%20Update%20Rollup%202%20to%20get%20better%20performance.%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ELastly%2C%20in%202020%2C%20we%E2%80%99re%20planning%20to%20invest%20into%20improving%20performance%20of%20SCOM%20consoles%20for%20other%20top%20user%20scenarios%20such%20as%20%3CSTRONG%3Ealert%2C%20health%20and%20performance%20views%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1592849%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22scom%20perf.png%22%20style%3D%22width%3A%20725px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212734i39936903575BFE67%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22scom%20perf.png%22%20alt%3D%22scom%20perf.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESCOM%26nbsp%3B%20performance%20has%20been%20one%20of%20the%20top%20user%20voice%20items%20over%20the%20years.%20It%20directly%20impacts%20the%20way%20our%20customers%20interact%20with%20SCOM%20including%20web%20console%20and%20operations%20console.%20We've%20made%20significant%20investment%20in%20this%20area%20to%20enhance%20your%20monitoring%20experience.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1592849%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESCOM%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESystem%20Center%20Operations%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

SCOM performance has been one of the top user voice items over the years. It directly impacts the way our customers interact with SCOM including web console and operations console.
This blog aims to highlight specific user scenarios which we’ve addressed in SCOM 2019 release and also the ones we intend to address in subsequent SCOM releases. Such user scenarios have been highlighted by our customers which is reflected in the SCOM performance issues that our customer support team resolves frequently.


In SCOM 2019, here are some of the scenarios that have been fixed:


1. Windows computer view in SCOM console:
A few of our customers gave us the feedback that opening the Windows computer view in the SCOM console took an unreasonable amount of time. As an example, one of our customers with 1600+ windows computers reported this issue. About 1400 servers and 50 clients (engineers) were affected because of this issue. While on an average, it took about 8-10 minutes for this view to load, in the extreme cases it took more than 20 minutes.
Given our customers are dependent on SCOM to provide timely information including but not limited to alerts, health and performance metrics of their applications and workloads, the performance of SCOM console is critical for customers’ monitoring experience. To decrease the load time for this view, we optimized the SQL query relevant to this view.


2. Changing the settings of a User Role
One of our customer had an environment with a lot of user roles, views, classes and relationship types in the database. The customer reached out to System Center team and explained that on an average, changing the settings of a user role, for instance, providing or revoking permissions on specific views or dashboards to a specific user role, took about 30minutes.
Further research suggested that many other SCOM customers with similar environment also experience similar problem. In fact, many customers concurred that changing setting of, say, 15-20 user roles took an entire day that impacted their productivity and ability to use SCOM console effectively. At a high level, the SQL queries that fetched relevant data and eventually helped change the settings of a user role was optimized. This optimization led to significant improvements in the load time for our customers.


3. Grooming of Maintenance Mode Staging Table
Our customer support team received a case from our customer that SCOM Operations Manager Datawarehouse grooming (emptying) of maintenance mode staging table was not occurring. This essentially meant that the table grew every day into millions of rows which eventually filled up the database that could potentially lead to additional cost to the customer to spin up a new database.
Furthermore, the increase in utilization of database is usually correlated with decrease in performance of SCOM console. To fix this issue we added an index to the maintenance mode stable table. This ensured that proper grooming of the table happened.

 

4. SDK service not starting and severe perf degradation leading to SCOM console not loading
While the technical details of the above mentioned issues are beyond the scope of this blog, suffice to say that a couple of SQL queries running in the backend were causing the above mentioned issues. In fact, a few our customers mentioned that they faced severe performance degradation since they upgraded from SCOM 1807 to 2019. The SCOM console took a long time to load and when it did even the basic tasks such as adding a management server to management group couldn’t be completed. To fix this issue, we optimized the SQL queries relevant to these issues which lead to significant performance improvement.


5. Reliability and performance improvement in XPlat agent

Prior to 2019, monitoring data related to health and performance were fetched through requests running in the same thread in the back end. Due to this design, any flaws in the perf channel affected the heartbeat requests and vice versa. This often led to system going into greyed out state.

In 2019, we isolated heartbeat threads from performance data related threads which meant that any malfunctioning in performance providers would not affect heartbeat request, thereby improving reliability of SCOM.

We also introduced filters in XPlat MPs to help customers in customizing their discovery and monitoring scope to entities of interest. With this filter, customers can define OMI queries to limit their workloads. For instance, in the SuSE platform there is a file system called “RaiserFS” which is not supported in core XPlat MPs, yet this file system was discovered with inappropriate performance data. Similarly, in case of hypervisor and container environments, large set of logical entities are created which should not monitored. This happens because of generic nature of XPlat agent which discovers all these entities. With the introduction of filters in Xplat MPs, discover and monitoring of all such entities can be fine-tuned further to improve performance and scale of XPlat agent.

 

If you have faced above mentioned issues in your SCOM environment, please let us know your current experience. Many of our customers are still using SCOM 2012 and SCOM 2016. Given that we will continue to make significant investment into improving SCOM performance in 2020, we strongly recommend that you upgrade your environment to the SCOM 2019 Update Rollup 2 to get better performance.

Lastly, in 2020, we’re planning to invest into improving performance of SCOM consoles for other top user scenarios such as alert, health and performance views