Help Please!
I need some info on performance in general or performance tuning SSRS. My database (and the apps talking to it) are taking a fucking dirt nap once people get report happy and start running a bunch of reports. We're not talking about a ton of long-running reports either.
This doesn't seem right to me, like we aren't doing something we should be. I'm googling as I type but I'm looking for some real world info from my peeps if you guys have any.