The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

Hi, I am starting the database with Sybase Central as a service with the following parameter:

-c 1024m -n data D:\database\data.db

When the database starts, the initial memory is about 14mb. Is there a way that I can start the database with the whole 1024m that is reserved for the database? Right now, it starts at 14mb and gradually increase as needed.

Thank you for your help!

asked 03 Feb '16, 13:18

kennyli's gravatar image

kennyli
26112
accept rate: 0%


Start the database server with -cl 1024m.

HTH

permanent link

answered 03 Feb '16, 13:20

Mark%20Culp's gravatar image

Mark Culp
22.5k9129264
accept rate: 40%

Thanks for the quick answer, however when I put the parameter in

-cl 1024m -n data d:\database\data.db

the database server still begin with around 12M of memory only, and only increase when needed. Is it possible to start the database server and get the full 1024M of memory right away?

(03 Feb '16, 13:28) kennyli
Replies hidden

What makes you think it is using only 12M of memory?

When I start dbsrv9 with -cl 1024M it displays this...

Minimum cache size: 1048576K, maximum cache size: 1048576K

(03 Feb '16, 13:36) Breck Carter

I see. I was looking at the task manager's performance of the database server, and the memory used for the adaptive server anywhere database only begins at 14M, does it mean that the 1024M is already there, its just that windows doesn't detect the memory usage yet?

(03 Feb '16, 15:01) kennyli
Replies hidden
4

Windows Task Manager only displays the size of the process' resident (working set) memory and not the amount of memory that the process has allocated. You can use resmon or perfmon to look at the process 'commit' size to get the true amount of memory that is allocated by the process.

(03 Feb '16, 17:38) Mark Culp
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×11

question asked: 03 Feb '16, 13:18

question was seen: 340 times

last updated: 03 Feb '16, 17:38