New system procedures

The following new system procedures provide some of the functionality for the features described earlier:

Table 6-4: New system procedures

Procedure

Function

sp_bindcache

Binds databases, tables, indexes, or text or image chains to data caches.

sp_cacheconfig

Configures named data caches and provides information about caches.

sp_cachestrategy

Enables and disables caching strategies and large I/O for specific tables and indexes.

sp_chgattribute

Changes the max_rows_per_page value for future space allocations of a table or index.

sp_displaylevel

Sets and displays a user’s display level. The display level determines which SQL Server configuration parameters are displayed in sp_configure output.

sp_dropglockpromote

Removes lock promotion values from a table or database.

sp_helpcache

Provides information about cache overhead requirements and provides information about caches and cache bindings.

sp_helpartition

Lists the first page and the control page for each partition of a partitioned table.

sp_logiosize

Changes the log I/O size used by SQL Server to a different memory pool when doing I/O for the transaction log of the current database.

sp_poolconfig

Configures pools within named caches to enable large I/O.

sp_procqmode

Reports the subquery processing mode of an object.

sp_setpglockpromote

Sets or changes the lock promotion thresholds for a database, table, or for SQL Server.

sp_unbindcache

Unbinds a specific database, table, index, or text or image object from a data cache.

sp_unbindcache_all

Unbinds all objects bound to a cache.