I'm doing some benchmarking to see how exporting query results to csv using ssrs via pure C# compare to each other. We want to take advantage of the subscription and scheduling benefits of ssrs but there seems to be a lot of overhead in doing direct csv exports. Test case is a query that exports about 200k rows worth of data (query only takes about 1.5-2 seconds). Exporting to csv in C# takes 17 seconds where ssrs takes 87 seconds. Apparently, even with a direct render to csv, ssrs is still copying results to reportservertempdb (35 seconds) and then still taking the duration to render the csv. Snapshotting won't help because the report is parameterized and will change frequently. My question is, can you tweak ssrs to do a pure csv export without all the overhead? Or, is there a really good reason for all the overhead? Maybe better concurrency mgmt or something? Would a data driven subscription cut out this overhead? Any insight would be appreciated.

Hi Cgierlack, It seems that this is an normal behavior when exporting large report to the CSV format. Please see the following thread to get more information: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/458554ac-b82e-45b4-9e4e-e4be8de4780dRegards, Leo

Hi Cgierlack, Just adding to Leo's answer, the issue may also be related to the high the memory presure. In this condition, you can try to increase your server RAM and check the performance again. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support

Hi Cgierlack, It seems that this is an normal behavior when exporting large report to the CSV format. Please see the following thread to get more information: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/458554ac-b82e-45b4-9e4e-e4be8de4780dRegards, Leo

That's really disappointing. I was hoping 2008 R2 or 2012 would handle larger reports better but it seems they are only equipped for smaller, executive style reports. Thanks for the responses.