Memory usage of dataserver question 
Author Message
 Memory usage of dataserver question

We have been twiddling the memory given to dataserver (via sp_configure).
Then we look in `top' to see how much memory he is actually using.

When he was given 12M (according to us) he never used more than 8M.
Right now he's been given 30M (according to us)  and we never see him
using more than 10M or so in `top'.  (e.g. in 2k pages, to get him to
use 30M we ask him to use 15000 pages).

Is there a good explanation?  Is this a bug?  Should we "give him" 50M
so as to get him to actually use 30M?

Does memory really turn into better performance?  Oh, this is on a Sun SS2.

Ajay Shah                                                  Work: 91-22-4300531
Centre for Monitoring Indian Economy                       Fax:  91-22-4370558

Sun, 31 Mar 1996 13:15:15 GMT
 [ 1 post ] 

 Relevant Pages 

1. ADO Causes 100% Memory Usage/Increases in VM Usage

2. SQL memory usage question

3. Memory Usage question

4. Memory usage question

5. memory usage questions

6. Memory Usage Question

7. Sybase V5.0 Memory Usage Question

8. A question on shared memory usage

9. Shared Virtual Memory Usage Question

10. Dataserver could not stay resident in main memory

11. Migrate from Progress dataserver to Oracle dataserver

12. WARNING: memory usage in procedure headers (1) does not match memory usage count in Pss (66) for server process id 63

Powered by phpBB® Forum Software