DBCC RESOURCE
This command shows the server’s level RESOURCE, PERFMON and DS_CONFIG information. RESOURCE shows addresses of various data structures used by the server. PERFMON structure contains master..spt_monitor field info. DS_CONFIG structure contains master..syscurconfigs field information.
Syntax:
DBCC resource
This is an example:
DBCC TRACEON (3604)
DBCC resource
DBCC TAB
You can use the following undocumented command to view the data pages structure (in comparison with DBCC PAGE, this command will return information about all data pages for viewed table, not only for particular number)
Syntax:
DBCC tab (dbid, objid)
where:
dbid – is the database id
objid – is the table id
This is an example:
DBCC TRACEON (3604)
DECLARE @dbid int, @objectid int
SELECT @dbid = DB_ID(‘master’)
SELECT @objectid = object_id(‘sysdatabases’)
DBCC TAB (@dbid,@objectid)
Published with the explicit written permission of the author. Copyright 200
]]>