Seagate ST43401N/ND Technical Information PDF herunterladen (Seite 94)

6-14 Implement: Making Required Database Administration Changes

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

I/O the server has to do and the faster it performs. However,

increasing the data cache size past an optimum amount leads to

diminishing returns and wasted space.

➤

Note

This outline of memory does not include other Sybase products that may be

running on the same machine. You need to take these into account when

planning to increase memory. Use the calculations in Chapter 3, “Analyze:

Documenting Your Environment” in the section “Physical Memory

Utilization” or check the installation guide for minimum RAM requirements.

Increasing Memory: Three Estimating Techniques

You can use any combination of the techniques described below to

estimate your increased memory needs. A certain amount of

experimenting may be necessary.

1. Calculate Data Cache Based on Error Logs

This method of comparing memory usage between old and new

servers can be used when you have upgraded a test or development

system. It requires that you have error logs from both the earlier SQL

Server and Adaptive Server.

Your 4.9.x or 10.x SQL Server error log contains lines similar to the

following:

Number of proc buffers allocated: 556

Number of blocks left for proc headers: 629

Number of buffers in buffer cache: 2072

After 11.0.x, the line, “Number of buffers in buffer cache,” was

changed to this:

Memory allocated for the default data cache: 4144Kb

If you have named caches in 11.0.x, each one has a similar line.

1 2 ... 89 90 91 92 93 94 95 96 97 98 99 ... 171 172

Keine Kommentare

Seagate ST43401N/ND Technical Information Seite 94