Monday, February 20, 2012

MSDE for Small Network System

Is it appropriate of using MSDE for peer to peer network system of a few computers, commercially?
All computers are working on Windows XP Pro, sharing DB each other via MSDE.
Are there anyone to advice us regarding the technical problems or licence problems?
Hi,
You can use MSDE on the peer to peer network. There are no licensing
issues, as MSDE is available free of cost and can be freely downloaded from
http://www.microsoft.com/sql/msde/do...s/download.asp
The technical issues that you may face are
1. There is not frontend for MSDE. you can use Web Data Administrator tool.
It can be downloaded from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
2. The data size in MSDE is limited to 2GB. The data cannot grow beyond 2
GB in an MSDE database.
3. MSDE has a workload governor that gets activated when there are more
than 8 process running simultaneously on an instance of MSDE. The workload
governor slows down the response of the MSDE instance. However, it does not
stop from multiple users using it. for more information on Workload
governor please visit
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
.asp?frame=true
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment