Hi,
Do you know the connection limit of express's reporting services?
As i know standard's version is unlimited, so how about the adv version.
Can I use this free version as web reporting tool for more than 100 users?
Many Thanks....Hi,
yes, you have no query governor anymore, but you are restricted to the
hardware limitations of SQL Server Express, so scaling up with Express
is limited. There are also no connection limitations.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi Jens,
Thanks.
Do you have any benchmarking info between express & standard in term of RS
performance (no db installed in express) where express only support One CPU
& allocate 1G Mem.
What I want to know how RS consume server resources so i can make a decision
to choose express RS or standard RS for my web report which will support 100
users.
Many thanks again.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169538427.949486.105720@.v45g2000cwv.googlegroups.com...
> Hi,
> yes, you have no query governor anymore, but you are restricted to the
> hardware limitations of SQL Server Express, so scaling up with Express
> is limited. There are also no connection limitations.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Hi,
this is really hard to tell, there is no rule of thumb as it has many
influencing factors. What about processing time for the reports, how
often do they access the reports, how big are the reports, which
reporting format will they produce, etc. You will have to run a load
test on the machine to see how your report are performing for getting a
performance measure to scale you machine.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Thanks jens, will try and test.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169584143.023207.298610@.j27g2000cwj.googlegroups.com...
> Hi,
> this is really hard to tell, there is no rule of thumb as it has many
> influencing factors. What about processing time for the reports, how
> often do they access the reports, how big are the reports, which
> reporting format will they produce, etc. You will have to run a load
> test on the machine to see how your report are performing for getting a
> performance measure to scale you machine.
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
No comments:
Post a Comment