4 Replies Latest reply on Apr 24, 2017 1:29 AM by Peter Jasenak

    MSSQL - ARS Remedy queries generation

    Peter Jasenak

      Hello colleagues

       

      is there any way to change the method of query generation from Remedy? Most of requests are classified as non-parameterized ad-hoc queries what is not very optimal for SQL server as it can't use produced query plans again. It still has to calculate new query plans what is also floating the plan cache. We have 160000 plans in the cache and 150000 are used just once. SQL server is set for Ad-hoc optimization and parameterization is forced an nothing helps