General discussion

Locked

Pevasive SQL, Citrix on 2003 Server

By ktucker ·
Hopefully the wealth of knowledge from the techrepublic group can help me with this problem. I am currently running 2003 Server (specs are moot on all server listed ... all are more than enough power (overkill even (dual xeons, 2 - 4 gigs of memory etc.) with a Pervasive SQL Database powering one of our applications. On that same network segment I have two Citrix servers also running on Windows 2003 in a farm setup (again Xeons with minimum 2 gig of memory). The Dbase server is my DC and running active directory ... the citrix machines are simple member servers on the network within the domain. DNS and DHCP is handled through the DC. All other workstations on the network (windows 2000 and windows XP) attach to the Dbase server and run the application no problems (outside of application glitches) but this is where the problem comes in ...

When clients try to connect to the citrix server they have a problem executing the application attached to the database. This problem only begins happening after maybe 4 hours sometimes clients can connect throughout the day (8 - 5) and about the last hour or so start having issues where clients are kicked out of the application. The issue is not a connection to the citrix server because at any point during the day the clients can connect to the citrix server but the execution of the application associated with the Dbase is the problem that will not start. If I reboot the server (Citrix) everyone can connect again no problem for again the same period of time if all users are logging in. I have 2 servers and about 50 users split between the two. If users were to connect to the Citrix boxes during this problem time all other applications will run lightning speed but this particular app. with the Pervasive SQL dbase will not. If will not kick or lock the citrix users all at one time but almost one by one. The systems are clean from any virus or spyware, they are firewalled to only allow necessary ports from the outside. If I try to run the application locally on the Citrix machines during this problematic time the application still will not open or will take forever to even open (timed at 14 minutes on one instance). If I start logging people off the server one by one the application will eventually come up faster. Meanwhile as I mentioned the servers are more than capable of handling the load ... my cpu using when everyone is logged into the server is about 7 to 15% (max) and the 15 is when I have more than half on one machine. I have work with the application designer (Mom and Pop type company) but their programmers have only concluded that the problem is with something holding up the database from starting. Citrix says it is a Pervasive issue and Pervasive wants to point fingers at Citrix (typical). The servers are running CA antivirus and I have made the application exempt for the AV to prevent scanning of the app and the dbase. All the updates are done on the servers so everything is up to date there. The version of Pervasive is 8. The server also have static addresses assigned on the same private network. Hopefully this is enough info for anyone who might have experienced a similar incident and has any ideas. Thanks guys and gals.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Not used this particular set up but my

by Tony Hopkinson In reply to Pevasive SQL, Citrix on 2 ...

first thought is that the application is using up connections to the database to the point where the DBMS is paralysed. Don't know pervasive or the app but I'd check out how many connections the db app was using and how many sessions pervasive thinks it's got. The other possibility is that the app has some other resource hogging feature, that after a certain amount of people have connected in to use it, has the DBMS thrashing badly. That one I have seen. All it was as a timeout facility, with a automatic retry. The retry always tripped as the DBMS got loaded up.

Collapse -

Posted 3 times

by BFilmFan In reply to Pevasive SQL, Citrix on 2 ...

It appears that this discussion has been posted 3 times. My original comments are here: http://techrepublic.com.com/5208-11183-0.html?forumID=89&threadID=187014&messageID=1915655

Reading Tom's comments, I was thinking you might want to check the following settings:

Adjust the number of LDAP connections allowed using NTDSUTIL:
http://support.microsoft.com/default.aspx?scid=kb;en-us;315071&sd=tech

Collapse -

Will give it a shot

by ktucker In reply to Posted 3 times

Sorry for the three post guys ... wanted to cover the 3 areas the topic fell in. I will give those suggestions a try and see if the vendor might be able to look at how Pervasive is handling users a little more. Any more suggestions would be appreciated. Thanks.

Collapse -

???REBOOT SOLVES???

by entawanabi In reply to Pevasive SQL, Citrix on 2 ...

When you "BOOT" you are making thousnds of copies of something that are generally used once and disposed of. .If, as it implies in the statement, a rebootting solves the problem temperarily then it "SEEMS" that you may need to get a traffic count (don't know how to do that) and adjust or something for it, allow(?).not sure where to go next
OH! I found out what a SQL Server is, It is a 'Sequencial Server' You're in line at the only cash register at the grociery store, a very fast one that works only in a linier fashion. Now I don't know what a Citrix server is yet BUT the SQL Server ido know of. It operayes in a linier fashion of operations and actions that occur in a particular Hardware order and then a particular software order? If this helps please let me know how as I've met the limit of my knowledge about them and it is important at times in my job and all the ones I've installed or ordered were specific to the business and sometimes the particular application.

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums