Seagate ST43401N/ND Información técnica descargar pdf (Pagina 96)

6-16 Implement: Making Required Database Administration Changes

If Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5

Use master instead of sybsystemprocs to run these commands on a 4.x

server.

This

dbcc command reports the number of memory pages used for

the stored procedure whose object ID you enter. Compare results on

the old and new systems. Use these results to estimate the procedure

cache size needed to accommodate the objects such as triggers,

views, and stored procedures that you want to hold in cache

simultaneously.

3. The Simple Way: Increase by Percentage

If you want to forgo calculating present and future memory use, the

following chart gives a rough estimate for increasing memory to

maintain approximately the same server performance you are now

getting.

How to Increase Memory

The precise steps you take to increase memory will depend your

needs and environment. To increase the amount of space available to

Adaptive Server, do some or all of the following:

• Increase the amount of RAM in the machine

• Increase the amount of shared memory allocated by the operating

system to Adaptive Server. See the installation guide for

information about increasing shared memory.

• Increase the

total memory parameter using sp_conﬁgure (not to

exceed the amount of memory allocated to Adaptive Server by

the operating system)

• Adjust the

procedure cache percent as necessary to produce the right

amount of procedure and data cache. The

procedure cache percent

determines how much of the memory not used by the kernel goes

to procedure cache. The remainder goes to data cache. This is the

only way to adjust data cache.

Table 6-6: Percent memory increase

From

Release...

Increase

Memory by...

4.x 125%

10.x 50%

11.0.x 25%

1 2 ... 91 92 93 94 95 96 97 98 99 100 101 ... 171 172

Sin comentarios

Seagate ST43401N/ND Información técnica Pagina 96