SCOM DW XML Query
I created an index on the ManagedEntityProperty table for the SCOM DW database (https://technet.microsoft.com/en-us/library/gg508713.aspx). It is a primary xml index so we can query the PropertyXML column efficiently.
Now, the query uses the index properly, but it still takes 85% of time on parallelism. Is there a way to fix that?