Our AS database has 6 virtual cubes, each built on 4-5
source cubes. WE are using ASP.Net as the front end to
talk to AS cubes.
The number of users accessing the application is expected
to be a maximum of 1500 users. WE have 6 user roles
defined for the database and all teh rules are enforced on
the server side. At cube level, since we have defined some
cell secuirty, the roles are enforced on the client side.
However at the database the roles are enforced at the
server side.
We did a performance testing for 4 proc machine and could
see that for 50 concurrent users, AS was handling about
3500 locks.
Any reason or guess as to why or how the locks are
generated at the Analysis server side. Is it because the
roles are enforced on the server side?

Thanks
GS