This is a migrated thread and some comments may be shown as answers.

MSSQL Server database cache

1 Answer 193 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Vinod
Top achievements
Rank 1
Vinod asked on 02 Sep 2016, 10:34 AM

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

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 07 Sep 2016, 09:48 AM
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
Tags
General Discussions
Asked by
Vinod
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or