Seagate ST43401N/ND Informations techniques télécharger pdf (Page 92)

6-12 Implement: Making Required Database Administration Changes

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

procedures, views, triggers, rules, and defaults. The problem is due

to a bug that caused query trees of objects containing

isnull to be

stored incorrectly.

To see which objects contain the

isnull function, use this command:

select name, type from sysobjects

where type in (‘V’, ‘P’, ‘R’, ‘D’, ‘TR’)

and id in (select distinct id from syscomments

where lower(text) like ‘%isnull%’)

order by type, name

Identify those objects that contain isnull with differing datatypes.

Datatypes to be aware of include tinyint, smallint, numeric, decimal,

ﬂoat(n), real, double precision, smallmoney, or money. After

upgrading, drop and recreate those objects.

For more information, see Technical Information Library.

Increased Memory Requirements

This section provides information relevant to all upgrades from

earlier releases. Memory requirements have increased signiﬁcantly

between SQL Server 4.x, 10.x, and 11.0.x, and Adaptive Server 11.5.

The increased memory needs reﬂect the following:

• Growth of the Adaptive Server binary

• Addition of XP Server and Omni services

• New structures in memory, such as user log cache (new in 11.0)

and metadata cache

• Growth of old structures such as locks, user connections, and

open databases

• Growth of compiled objects in procedure cache

The larger server kernel and compiled objects will grab space from

data cache, affecting performance, if you do not increase total

memory resources.

This section explains memory and discusses ways of determining

how much more memory you need.

Understanding Memory

Read this section if you want an overview of the areas of memory, or

use it for reference later.

1 2 ... 87 88 89 90 91 92 93 94 95 96 97 ... 171 172

Pas de commentaire

Seagate ST43401N/ND Informations techniques Page 92