×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Optimizing SQL v8.5 help required.

Optimizing SQL v8.5 help required.

Optimizing SQL v8.5 help required.

(OP)
Hi,  I have a custom App using SQL 8.5,   My problem is that this App misbehaves under load, my concern is that I have not optimised the Pervasive settings.   I have just installed the default settings.  I have around 60 users logged in under peak load.  Should I be changing the default settings to increase Threads and timeouts ect.

Any help would be appreciated, or if you could point me to a reference so I can check what each setting does and the +ves and -ves of each setting.

Thanks

RE: Optimizing SQL v8.5 help required.

What operating systems are we talking about here?



RE: Optimizing SQL v8.5 help required.

Also, what do you mean by "this App misbehaves"?
THe best resource for the settings is going to the be the documentation.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Optimizing SQL v8.5 help required.

Does the application use ODBC, Btrieve, OLEDB, or another interface?  
WHat's the application doing when it "misbehaves under load"?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Optimizing SQL v8.5 help required.

(OP)
Windows server 2003
ODBC

Via Citrix Presentation 3

Misbehave's in that the App Freezes for random users, and, after the citrix session has been terminated and the session loged out, then when they or others try to log into the app they get through the login security phase but then the app freezes.   After several attempts to log in eventually the  user can log back in.    At first the freezes appeared to be when the users were printing.  (via Citrix and Crystal reports) but the freeze has also been happening when the user have not been attempting to print.

Where "specifically" in the mound of documentation.   Even searching Google with "pervasive optimization" and other variants does not find specific setting information.

An example of what I am trying to find out is ...

What value should I put in the "communication threads" setting under the pervasive control centre, server,configeration,performance tuning section?   AND what are the pros and cons of changing it from the default value?

Thanks for the replies so far.

RE: Optimizing SQL v8.5 help required.

Here's some performance info:
http://www.pervasive.com/library/docs/psql/850/advops/optimizing5.html#69809
and
http://www.pervasive.com/library/docs/psql/850/advops/configref2.html
Freezes usually wouldn't be a "communication threads" issue.  When this "freeze" occurs, does the PCC fail to connect?  If so, what error is seen?  If the freeze is mainly happening when printing, make sure the the Network cards aren't "caching" cards. I've seen, in lower traffic networks, where caching cards hold the information too long and it looks like the app freezes..

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Optimizing SQL v8.5 help required.

(OP)
The PCC does fail to connect when the freeze occurs.

Thanks for the urls, I will check them out.

RE: Optimizing SQL v8.5 help required.

What error does the PCC give?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Optimizing SQL v8.5 help required.

(OP)
I have not waited for it to give an error,  it just sits on the screen and eventually says "not responding"  so then I just end the the task via task manager.

How often would you recommend rebooting the server?   I am not a great fan of setting automatic/scheduled reboots, even though I know obout memory leakage.  I reboot this dataserver every fortnight give or take a day or two.

RE: Optimizing SQL v8.5 help required.

(OP)
Thanks for the replies Mirtheil, the URL's give me the exact information I was looking for.   I can experiment over the next few weeks with adjusting some of these setting,  now that I know exactly what it is they do.

Thanks again.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close