Hello everyone.  I have my DBISam on a file server currently and I find it can slow down occasionally when other task are running on the server.  I am considering just moving it onto a spare desktop OS (Windows 7 Pro) just for the databases.

Do I need to have the database server on a Server OS or will this work fine on Windows 7 Pro for around 60 users across the day.

Thanks
David.

David


Ouch - can you tell me how long this piece of string is

A lot depends on the type of load, wether you're using c/s or f/s, how the PC is configured and the network. I ran DBISAM and the ElevateDB on a non-server machine for c10 users and that was fine both in f/s and later in c/s.

Can you post the spec of the machine you're proposing to use and the work pattern? There should be people on thing ng (not me these days) whoi should be able to give an idea of how well it will perform.

Roy Lambert

Hi Roy.

The desktop machine is quite a good spec its an i7 3GHz 16GB ram Windows 7 64 Bit with a Kingston SSD drive.

Roy Lambert wrote:

David


Can you post the spec of the machine you're proposing to use and the work pattern? There should be people on thing ng (not me these days) whoi should be able to give an idea of how well it will perform.

Roy Lambert

On 11/23/2020 6:05 AM, David wrote:
> Hello everyone.  I have my DBISam on a file server currently and I find it can slow down occasionally when other task are running on the server.  I am considering just moving it onto a spare desktop OS (Windows 7 Pro) just for the databases.
>
> Do I need to have the database server on a Server OS or will this work fine on Windows 7 Pro for around 60 users across the day.

AFAIK there is a concurrent connection limit on Windows desktop OS (20
connections i think) so i suspect you will have problems with 60 users.

Any way to throttle those other tasks ?

Raul

Raul


I thought I remembered something like that. I not sure about actual physical connections but apparently its in the EULA. Here's an interesting article on it.


https://social.technet.microsoft.com/Forums/en-US/7f2ab78b-eec0-43e0-af7f-f1ddf21a704a/windows-7-what-constitutes-a-connection-under-the-20-connection-limit?forum=w7itpronetworking

Its a bit confused about what is a connection

Roy Lambert

Raul wrote:

AFAIK there is a concurrent connection limit on Windows desktop OS (20
connections i think) so i suspect you will have problems with 60 users.

Any way to throttle those other tasks ?

Raul

I thought that was only relevant to file sharing not TCIP as I am using the DB Client server.  Sorry should have put that in at the start

David.

On 11/23/2020 12:02 PM, David wrote:
>
> I thought that was only relevant to file sharing not TCIP as I am using the DB Client server.  Sorry should have put that in at the start
>

Info on this is murky - there are EULA limits but also i believe actual
TCP limits that are enforced.

I'm no lawyer but i think EULA says file/print sharing is ONLY "server
type" capability you're allowed to share and then it's limited to 20
devices.

AFAIK it's managed by limiting inbound TCP connections since all of it
is TCP these days.

I would very much suggest you actually test it out with 40-60 concurrent
unique connections before putting into production

Raul

Raul wrote:

On 11/23/2020 12:02 PM, David wrote:
>
I'm no lawyer but i think EULA says file/print sharing is ONLY "server
type" capability you're allowed to share and then it's limited to 20
devices.

AFAIK it's managed by limiting inbound TCP connections since all of it
is TCP these days.

I would very much suggest you actually test it out with 40-60 concurrent
unique connections before putting into production

Raul

I found the post below from TIM that seems to imply there is no OS limit for TCP/IP on non windows based connections such as DBISam.  I hope TIM or someone else sees this and can confirm this.  The info out there is confusing at best.

Thanks
David.

https://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_cs&msg=5489&start=31&keywords=tcp%20ip&searchbody=True&forum=DBISAM_Announce&forum=DBISAM_General&forum=DBISAM_SQL&forum=DBISAM_CS&forum=DBISAM_ODBC&forum=DBISAM_Beta&forum=DBISAM_Binaries&forum=DBISAM_Suggestions&forum=DBISAM_ThirdParty&forum=DBISAM_Discussion#5489

David


From the bit of reading I've done I think Raul is correct, the restriction is legal not physical and you're legally limited to only file & printer sharing. How many people adhere to the legal limites I don't know.

The thread you referenced also has the way to calculate the memory needed which might end up being a physical restriction.

Roy Lambert

Roy Lambert wrote:

From the bit of reading I've done I think Raul is correct, the restriction is legal not physical and you're legally limited to only file & printer sharing. How many people adhere to the legal limites I don't know.

The thread you referenced also has the way to calculate the memory needed which might end up being a physical restriction.

Roy Lambert

Sigh!  Windows licensing has always been confusing at best.  I obviously don't want to do anything illegal, but the way I read it, TCP/IP was except unless it is File or Printer sharing where the limit comes into force.  So you could for example have a webserver using Windows 7 to many people but don't need a seat per user as long as only TCP/IP traffic.  Having to have a server OS when no print or file sharing is involved seems like a sledgehammer to crack a nut approach.

Thanks for your input guys.  I will need to think this approach over.

Regards
David.