Quoted from http://blogs.msdn.com:

User Instances (also known as RANU) available with SQL Server Express Edition, are NOT RECOMMENDED for hosting environments.

I have a server running Server 2008 R2 Web Edition with IIS 7.5 and Sql Server 2008 R2 Express installed.

I have only 3 friends as my hosting clients. Each has a restricted Local User Account on the server.

What is the drawback of using user instance in production environment?


Rather than considering the limitation in memory usage and database size that I know, let us consider the user instance only, why isn't it recommended?


@Recycle: It's just a close vote. It will age away after a couple of days. Nothing to worry about.

Written by Robert Harvey

@Robert: did you have a reason to do a close vote?

Written by xport

I didn't close vote. Someone else did. It's OK, it takes 5 votes to close a question. If there are no more close votes, this one will disappear after a couple of days.

Written by Robert Harvey

@Robert: I am so sorry. I misunderstood your comment.

Written by xport

No worries.....

Written by Robert Harvey

@Recycle, Robert Harvey is a moderator, so if he had voted to close this question, it would be closed. It only takes 5 votes when it's us lesser mortals. :)     And, no I didn't vote to close, I followed a link from your meta question.

Written by Brock Adams

Also, to the anonymous close-voter, this is on topic for StackOverflow.

Written by Will

Accepted Answer

I think that the answer to your question comes with the definition of the RANU

What is RANU

and also read the http://msdn.microsoft.com/en-us/library/bb264564(SQL.90).aspx

The RANU starts a seperate instance Process of SQL Express for every user, so in a share enviroment with let say 30 sites that needs access to SQL, then SQL run 30 instances at the same time, that is takes as you understand a lot of recource/memory etc. Also as say in the article the first time SQL Express run for every user is make copies of all system database to create this user instance.

In a single user machine to run one process is normal, but if SQL Express starts to run many instances then you take a lot of resource, memory, and this is not easy to administrate, update etc.

In the article on the link there are more detail informations about this.

Written by Aristos
This page was build to provide you fast access to the question and the direct accepted answer.
The content is written by members of the stackoverflow.com community.
It is licensed under cc-wiki