In a recent project that was undertaken a challenge was presented. “We have an access database application that we currently install on end users machines, but we want to move it to a cloud based service”<\/p>\n
The software was a split access database, usually only one organisation can access the relevant access database backend front a distributed frontend. There was a direct one-to-one relationship between the host windows machine and the database for the organisation… IE each\u00a0organisation needed to have a dedicated machine – be it on premise or hosted service. This involved either ongoing maintenance and troubleshooting of dissimilar hardware\/software environments or costly windows server hosted solutions.<\/p>\n
This was before I.T. Discovery was involved…<\/p>\n
By utilising MS Terminal Services and Active Directory, we were able to craft a server that is able to host MULTIPLE MS ACCESS databases. Each organisation has its own database and accesses the front end via Terminal Services Remote Desktop. Within this managed environment, the deployment of new organisations is a snap, adding new users via a scripting mechanism.<\/p>\n
Here is the impressive part:-<\/p>\n
Server Specs<\/strong><\/p>\n 6 core CPU<\/p>\n 32GB RAM<\/p>\n Raid 5 Disk Array Currently 700GB<\/p>\n 10m\/bit internet link<\/p>\n The interesting thing noted about this deployment is that it is definitely not the cpu or hdd resources limiting more concurrent users, we hit the 32gb ram ceiling with around 110 concurrent users with this memory footprint per user. With more memory (Server Enterprise) this solution is SCALEABLE.<\/p>\n To achieve this with a SQL mutliple tenant environment, each instance of SQL server would have required an even very conservative 1gb, this limits the server to 32 organisations.<\/p>\n All in all the JET database engine is very efficient and fast when accessing data LOCALLY, the important this is keeping the front and back ends physically on the same machine and avoiding any network type access.<\/p>\n","protected":false},"excerpt":{"rendered":" In a recent project that was undertaken a challenge was presented. “We have an access database application that we currently install on end users machines, but we want to move it to a cloud based service” The software was a split access database, usually only one organisation can access the relevant access database backend front… \n
Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=\/wp\/v2\/posts\/2192"}],"collection":[{"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2192"}],"version-history":[{"count":5,"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=\/wp\/v2\/posts\/2192\/revisions"}],"predecessor-version":[{"id":2197,"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=\/wp\/v2\/posts\/2192\/revisions\/2197"}],"wp:attachment":[{"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itdiscovery.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}