beautypg.com

Sybase 11.9.x-12.5 User Manual

Page 438

background image

Server Error Messages 10400 - 10499

1112

10450

10

number of open objects sets the maximum number of database objects that can be open
at one time on SQL Server. The default run value is 500.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10451

10

number of preallocated extents specifies the number of extent structures allocated in a
single trip to the page manager.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10452

10

number of remote connections controls the limit on active connections initiated to and
from this SQL Server. The default is 20.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10453

10

number of remote logins controls the number of active user connections from this SQL
Server to remote servers. The default is 20.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10454

10

number of remote sites controls the number of simultaneous remote sites that can access
this SQL Server. The default is 10.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10455

10

number of sort buffers specifies the number of buffers used to hold pages read from input
tables.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10456

10

number of user connections sets the maximum number of user connections that can be
connected to SQL Server at one time.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10457

10

page lock spinlock ratio specifies the ratio of spinlocks protecting the internal page locks
hash table.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10458

10

page utilization percent controls when SQL Server performs an OAM (Object Allocation
Map) scan to find unused pages. The default run value is 95.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

10459

10

partition groups sets how many partition groups to allocate for the server. Partition
groups are used by SQL Server to control access to individual partitions of tables.

Explanation:

This is an informational message. Unless otherwise specified, no action

is required. Contact your System Administrator about any warning issued in the message.

Number

Severity

Text and Explanation