I am seeing a BT excessive splitting too much and BT is finally disabled. I created a another BT with all same filters and splittings but how do I know how much number of Splittings I should restrict to?
What is the effect of this restricting to certain number? Do I miss any data while charting this BT?
I use this BT for charting.
If the number of splittings in the Server memory or in the Performance Warehouse exceeds the default limit of 50,000, the Measure Explosion Prevention disables creating measures for the affected Business Transaction.
Read the following link for preventing excessive split results:
Thanks for providing the link. I understand if the splitting limit of 50,000 is exceeded then creating measures is disabled.
What value I should give in 'Max no of splittings' so that I will not run into this issue? Default I gave 5,000 but it measures were disabled.
It depends on the number of splitting measures as method argument or return value.
I would suggest you to follow the link and adjust your BT accordingly: