?
Solved

Pervasive SQL 10.x ntdbsmgr process using 494Mb system memory

Posted on 2009-04-06
7
Medium Priority
?
819 Views
Last Modified: 2012-06-21
On a customer server (DUal Xeon 3.0 and 3Gb memory), Pervasive SQL 10.x is installed.
The process names ntdbsmgr is according to taskmanager using 494Mb of system memory.

Is there a possibility to reduce the memory ammount in pervasive SQL (PSQL)?

0
Comment
Question by:techneitsolutions
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 24078368
The database takes the memory in order to provide a data cache, which reduces disk I/O, and thus improves database performance.   Before reducing the PSQL cache size, you should look at your database size and decide if this makes sense.  If the sum of the sizes of all of your Btrieve files are only 200MB, then obviously you can shrink the L1 cache size (Cache Allocation) to 200MB and disable L2 cache (Max Microkernel Memory Size).  If your files total 4GB, though, then decreasing the cache will likely impact performance of the database.  

Honestly, with 3GB of RAM, using 0.5GB for the database seems pretty reasonable.  Feel free to set it as low as you want, though.
0
 

Author Comment

by:techneitsolutions
ID: 24078395

Can you describe how:
- i can find en check the db size
- i can set the cache size

thanks,
Pieter
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 24078447
>>- i can find en check the db size
Look for your database files.  These are defined by the application developer, and could have ANY extension, though they usually have an extension of BTR, MKD, DAT, FIL, or the like.  When in doubt, run the Pervasive Monitor program while users are in the application and look at the Microkernel/Active Files screen. Then, look at these files in the OS and sum up their sizes.

>>- i can set the cache size
Start/Run/PCC.  On the Welcome Screen, click on the link for Configure Local Engine.  Go to the Performance Tab.  The aforementioned settings will be there.  After changing them, restart the engine (or just reboot, if that's easier).  See the Help/Documentation screen in the PCC for more complete details on each of the settings.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:techneitsolutions
ID: 24084405
I found some *.BTR files with the monitor application. Those are located in the folder that the clients use and take up about 5 Gb.

In attach the detail settings of the performance and memoery usage tabs.


perf1.jpg
perf2.png
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 24086416
You can certainly decrease memory usage, at the possible expense of performance. Its your call.
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 1500 total points
ID: 24291039
My first reply was the correct way to decrease the memory usage - by decreasing the engine settings that allocate memory.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question