D.M. Corbett (7/7/2014)
The ReportServer has very, very little processing to do. It is the other SQL database that is the work horse.So that is why I can't figure out why in Task Mananger ReportingServicesService.exe is using 667,440k memory use and sqlserve.exe is using 542.080k memory use.
Tough to say not knowing your memory configuration.
The ReportServer database will do very little work. But the executable for Reporting Services can do a fair amount of work because of the rendering, sorting, grouping etc that it must do.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events