August 27, 2007 at 5:50 am
We are having some performance issues with our Reporting Services deployments. We typically deploy using SQL Express with Advanced Services, to include the Reporting Services. However, our reports are running significantly slower on the SQL Express edition versus Developer Edition of SQL/RS.
We tested this out on our development machine (Dual XEON with 4GB RAM). We installed an Instance of Express side-by-side the Developer Edition. Same Database, Same Report. Renders in 2-3 seconds on the Developer edition, 15-20 seconds on the Express edition.
We tested the actual query, and in both instances it returns with sub-second response time, so don't think this is a SQL issue. It just renders VERY SLOW on the Express instance of Reporting Services when compared to the Developer edition.
Are there any known limitions on the Express edition of RS? I know SQL has some limitations, but the query runs the same on both, so it isn't that.
Any thoughts of things to check?
Thanks in advance.
Mark
August 27, 2007 at 7:30 am
SQL Server Express comes with 1gig ram restriction for everything you run, check the link below for details.
http://msdn2.microsoft.com/en-US/library/ms143685.aspx
Kind regards,
Gift Peddie
August 27, 2007 at 8:12 am
Yeah, I'm aware of that, but in my testing, I had VERY LITTLE running (just myself), so I don't think I hit that limit, but maybe that's the issue. I'll take a look, but don't think I was hitting a limit, but maybe with Reporting Services I am?
Also, as a side note, I have seen, in multiple instances, where the Memory Usage by the sql server process to be well over the 1GB limit - like 1.4GB. Not sure WHY, but I have seen that on multiple sites running the Express Edition.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply