December 19, 2006 at 4:44 am
I have a citrix farm fronting an application onto a sql database, I have performance problems for lots of reasons but I have no prior experience of citrix farms, about 500 users across 8 servers, any similar users with any observations concerning sql server through citrix?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 20, 2006 at 7:57 am
Hello Colin...We have clients running our app via Citrix against Sql Server and Oracle databases. There are so many variables to consider here. In our case, the client app is memory hungry which can cause issues on Citrix....we hit the OS memory limit after very few users connect. We recently did a Citrix 64-bit implementation that is rocking. The client also cleaned up their network, making a HUGE difference for our app.
Sorry I can't point to any specific, for sure fixed, but hope this helps a bit.
December 20, 2006 at 8:16 am
the 64bit is interesting - that's also the way forward for sql server, cheers.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 20, 2006 at 10:11 am
We use 70 citrix servers with a front end app to connect to a Oracle DB with 3800 users running on it. We also use Citrix for our SQL Server 2000 database as well. There are several key things to remember.
1. Citrix servers should be located in the same local network to the Database they are connected to. One big reason to use Citrix is to reduce network traffic.
2. Make sure the client app makes good use of stored procedures and not adhoc queries to handle the communication between the app and the Database. ( reducing network traffic )
3. Performance in these systems are limited by several things.
network, Citrix server performance, user desktop machine performance, database performance.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply