SQL SERVER WITH 100 USERS

GetSmart
GetSmart Member Posts: 17
edited 2009-04-17 in NAV/Navision Classic Client
Hi All,
We are having a customer with total number of users around one hundred at different Locations like Singapore and Malaysia. There is only one Server (SQL Server 2005) and all users need to access this server. What is the best approach to get a better performance. Looking forward for your valuable suggestions.

Thanks
GetSmart

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Use Citrix for remote access.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • AAshok
    AAshok Member Posts: 53
    Hi

    Use APP-V (Application virtualization).

    Check it.
  • davmac1
    davmac1 Member Posts: 1,283
    You don't give any details. Is this for one Navision SQL Server database that all the users will be using from the same application?
    If it is, then make sure you have the optimum hardware specs - separate RAID systems for OS, log, and data, and mayve tempdb.
    What version of SQL Server?
    Which edition - 64 bit standard with plenty of RAM is usually good enough.
    The server should be dedicated to SQL Server. Run your remote sessions on their own server(s) and make sure they have enough RAM and CPUs to handle the remote user load.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/

Categories