Seperating paid and free users on SQl Server 2008 R2

Posted by Alex on Server Fault See other posts from Server Fault or by Alex
Published on 2012-12-02T16:42:41Z Indexed on 2012/12/02 17:06 UTC
Read the original article Hit count: 127

Filed under:

Right now we have hundreds of "free demo" trial users on the same db server/database with our paid mission critical users.

I see this as both a security risk and a load issue. I have also seen cases where demo users run large reports and crash the server..

Does it make sense to separate these users into separate databases on SQL? Rather than just have one DB for all users?

My thinking is so one group of users has no effect on the other?

Can one group still pose a risk if we do this? I plan to have them on separate web servers also (windows 2008 r2, iis 7, .net 4.0)

© Server Fault or respective owner

Related posts about sql