
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,
float(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 significantly
between SQL Server 4.x, 10.x, and 11.0.x, and Adaptive Server 11.5.
The increased memory needs reflect 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.
Komentáře k této Příručce