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 connecti ons 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 t hat 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 intern al 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