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
sql
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