Hi, I have been trying to Test SSRS Reports' response times. We havea mix of reports. If I manually navigate to the SSRS Manager and load a report (generate) from there and manually time it and then record the same actions in Visual Stdio 2008 Team system and replay it back. The times in Visual Studio don't match up to the manual times.. Also looking at the execution logs, the times shown in there are different to Internet Explorer manual timmings and Visual Studio... I need to capture the Users Responce times they see and load test if possible. Can anyone shed some light on this and help me out?

Tom Take a look at the ExecutionLogStorage table and see how the executions are different. If your test scripts are executing reports by making a URL request (same as navigating to the report in Report Manager), I would expect the results to be similar. If the report is running in the Visual Studio designer, it will use the Preview GDI renderer rather than the HTML renderer. In that case, you're asking Reporting Services to execute completely different components. Another factor is the session or instance caching. The first time you run a report in a session, it will populate the cache for the session and then use it for subsequent executions. You can also configure each report to save semi-persistent instance cache. To get uniform testing, you should probably warm up the cache first or at least start with a cold cache in both scenarios. I'll be interested to know what you find.Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*