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
0
Comments
RIS Plus, LLC
MVP - Business Apps
Use APP-V (Application virtualization).
Check it.
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.
http://mibuso.com/blogs/davidmachanick/