SSRS 2008 TimeDataRetrieval timings
I have an odd performance report. When I run it under the following conditions SSRS ( UAT_SSRS
) and SQL Server ( SERVER_SQL
) I get a value of TimeDataRetrieval
23726. When I run it under a different SSRS ( PROD_SSRS
) server and still use the same SQL Server, the value TimeDataRetrieval
is 325952 (more than ten times more ) for the same parameters.
I understand this TimeDataRetrieval
covers both handling a connection and finding data from a dataset. Why is there such a huge difference between the two reports?
The value comes from the ReportServer database associated with the SSRS installation. This does nothing with the instance of SQL Server that hosts the RS databases.
So, this just goes to show that your SSRS product is about 14 times larger than your UAT SSRS. And they have different metadata databases even though they are on the same instance of SQL Server.
a source to share