How to prevent expansive queries from overloading the systems in AEM 6.1

Statement - How to  prevent expansive queries from overloading the systems

 Environment :

                         - AEM 6.1

Solution:

Add these JVM parameters in the AEM start script to prevent expansive queries from overloading the systems.

-Doak.queryLimitInMemory=500000

-Doak.queryLimitReads=100000

-Dupdate.limit=250000

-Doak.fastQuerySize=true

JVM arguments related findings

Finding ID	Title	Total Risk	Effort to fix
JVM1	Doak.queryLimitInMemory	High	Low
JVM2	Doak.queryLimitReads	Medium	Low
JVM3	Dupdate.limit	Medium	Low
JVM4	Doak.fastQuerySize	High	Low