Database Limitations

[Micheal]

Does anyone know of any database limitations? My client wants to
create a PWA site for each of his clients. What we propose is to
provision a new PWA site for each client such as http://server/client1,
http://server/client2, etc. The reason for this is for segregation and
for security but of course when a new site is created 4 databases are
created on the SQL server - my client is working with over 150 clients
so that could mean 600 databases on SQL server.

TIA

Micheal

 

[paul conroy]

Hi Micheal

I would suggest that you will likely need multiple SQL servers. The key
constraint here is the number of IOPS the customers will generate Vs the
number your SQL architecture can handle. You will more than likely reach a
performance bottle neck before you reach the database capacity of SQL server.

This scenario requires considerable planning, from how you intend to scale
the solution, volume of data, usage patterns, disk subsystem architecture to
authentication etc etc.

In answer to your question, I seem to recall the max number of DB's per
instance is about 5000, but I'm 100% on that number.

 

[Micheal]

Hi Micheal

I would suggest that you will likely need multiple SQL servers.  The key
constraint here is the number of IOPS the customers will generate Vs the
number your SQL architecture can handle.  You will more than likely reach a
performance bottle neck before you reach the database capacity of SQL server.

This scenario requires considerable planning, from how you intend to scale
the solution, volume of data, usage patterns, disk subsystem architectureto
authentication etc etc.

In answer to your question, I seem to recall the max number of DB's per
instance is about 5000, but I'm 100% on that number.





- Show quoted text -

Thanks very much for your answer Paul - the sites will be relatively
smal and data low so in the begining I will be OK. I was just worried
that there was some hidden limitation to the amount of PWA sites that
I could have.

Micheal

 

[paul conroy]

Are you considering a different SSP for each website. If so, there will be a
significant draw on the WFE servers (approx 30MB for App Pool), plus what is
used by the users. 150 web sites is technically possible and though
depending on usage may not be practical.

Id strongly recommend implementing a 64bit architecture to allow for upward
scalability.

Keep a close eye on application performance and be prepared to add
additional resources (cpu & mem) as well as servers to the farm if required.

 

[Micheal]

Are you considering a different SSP for each website.  If so, there will be a
significant draw on the WFE servers (approx 30MB for App Pool), plus whatis
used by the users.  150 web sites is technically possible and though
depending on usage may not be practical.

Id strongly recommend implementing a 64bit architecture to allow for upward
scalability.

Keep a close eye on application performance and be prepared to add
additional resources (cpu & mem) as well as servers to the farm if required.

Will do Paul. I think that one SSP for the PWA websites should be fine
- wouldn't you agree?

Micheal

 

[paul conroy]

Whether you have one or multiple SSPs will depend on a number of factors:-

a. Your administrative security bounderies. If one team is performing the
admin function across all sites then one SSP would suffice.
b. Having only one SSP means you only have one App Pool, so you won't be
able to throttle the resources used by each customer. Also if the app pool
crashes, then all customers will be affected.

 

[Micheal]

Whether you have one or multiple SSPs will depend on a number of factors:-

a.  Your administrative security bounderies.  If one team is performing the
admin function across all sites then one SSP would suffice.
b.  Having only one SSP means you only have one App Pool, so you won't be
able to throttle the resources used by each customer.  Also if the app pool
crashes, then all customers will be affected.





- Show quoted text -

Thanks Paul, I really appreciate your imput - this has helped a great
deal.
Micheal

 

[Ben Howard]

If I recall correctly, MS suggest a limit of 3-4 PWA sites per SSP, and I
think that there is a suggested limit of SSPs per farm. I've searched for
the documenation on this but cannot find it, so if anyone has any further
hard limits I'd like to know them
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/