Question

Werner Clausen on Wed, 29 May 2013 08:03:01


Hi,

As I read it, LocalDB is designed for developers and should not be used for production. Does that still apply when talking about SQL Server Express 2012 LocalDB?

I have a Windows service that needs a local storage. No other threads will be using that storage, but there might be several threads working on the storage at the same time. If I shouldn't use LocalDB (which I have tested to Work quite good) - what are my alternatives? It has to perform well as the process is very busy.

This service is both for servers (no users logged in) and for clients (users logged in). So I can't rely on some instance running in a users folder (that is how LocalDB Works right?) and I can't install full SQL/SQL Express.

Thanks.

--
Werner


Sponsored



Replies

rksqldba on Wed, 29 May 2013 08:32:25


Hi,

I think developers can use it in production as per below blog,

http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx

Werner Clausen on Wed, 29 May 2013 08:44:48


Hi,

I think developers can use it in production as per below blog,

http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx


Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

Hi, thanks. Yes I've read that too. But doesn't LocalDB (mdf file) require a user logged in?

--
Werner

rksqldba on Wed, 29 May 2013 09:42:35


Hi,

Localdb runs under the user profile. LocalDB instances are running as user processes. When different users are connected to LocalDB, they will end up with different LocalDB processes started for each of them.

You can also use the instance sharing feature of Localdb which allows to share a localdb instance with other users on the same machine.

http://msdn.microsoft.com/en-us/library/hh212961%28v=sql.110%29.aspx

Werner Clausen on Wed, 29 May 2013 12:03:11


Hi,

Localdb runs under the user profile. LocalDB instances are running as user processes. When different users are connected to LocalDB, they will end up with different LocalDB processes started for each of them.

You can also use the instance sharing feature of Localdb which allows to share a localdb instance with other users on the same machine.

http://msdn.microsoft.com/en-us/library/hh212961%28v=sql.110%29.aspx


Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

Thanks but not sure I understand the implications of what you say. What is the difference between localdb and localdb instances?

Or let me ask, can I implement a Windows service (that runs without anyone logged in) that uses a localdb MDF file as local exclusive storage?

--
Werner


rksqldba on Wed, 29 May 2013 12:43:44


Yes, you can use windows service.

Werner Clausen on Thu, 30 May 2013 07:04:49


Alright, I'll create a poc, thanks.