MSSQL Server database cache

2 posts, 0 answers
  1. Vinod
    Vinod avatar
    2 posts
    Member since:
    Jan 2015

    Posted 02 Sep Link to this post

    Hi,

    We are evaluating telerik reports.

    The below code snippet is defined in the Report Controller. Report works fine. But when a report is generated, the number of open connection of the telerikSession (used only for cache) is high and they do not get closed. I tried with one user, running one report and the number of openconnections is 30. Can you help me sort out this issue?

    static ReportServiceConfiguration preservedConfiguration;
    static IReportServiceConfiguration PreservedConfiguration
    {
    get
    {
    if (null == preservedConfiguration)
    {
    preservedConfiguration = new ReportServiceConfiguration
    {
    HostAppId = "ABC",
    Storage = new MsSqlServerStorage(ConfigurationManager.ConnectionStrings["TelerikSession"].ConnectionString),
    //Storage = new FileStorage(),
    ReportResolver = new OrgnResolver(),
    ReportSharingTimeout = 0,
    // ClientSessionTimeout = 15,
    };
    }
    return preservedConfiguration;
    }
    }

    Thanks

  2. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 07 Sep Link to this post

    Hello Vinod,

    The cache storage is frequently accessed on interaction with the report in the viewer. It is recommended to have a separate database for the cache storage and to use the same connection string and database in the application. In addition, connections will be handled automatically, unused ones should be released if needed.

    In addition, please upgrade to the latest available internal build that includes improvements in the Reporting REST service's cache management, which may be related to your issue. Internal build are available in your Telerik account - Downloads - Reporting - Latest Internal build, where you must use the account that downloaded Telerik Reporting.

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
Back to Top