sp_helpcache
select @@maxpagesize
sp_cacheconfig
sp_bindcache
sp_cacheconfig 'default data cache'

sp_configure 'max online engines'
sp_configure 'engines'
sp_configure 'number of locks'
sp_tempdb show
sp_configure 'max memory',20480000
sp_configure "max network packet size",2048
sp_configure 'allocate max shared memory',1
sp_configure 'additional network memory',2048
sp_configure 'memory'

sp_configure 'lock shared memory',1
sp_who
sp_configure 'procedure cache size',4096000
select * from master..syslogshold
sp_syntax 'alter'
dbcc traceon(3604)
dbcc memusage
dbcc traceoff(3604)

sp_object_stats

用户相关

USE master
go
EXEC sp_addlogin 'cwbase200','cwbase200','cwbase200','us_english',null,null,6,null
go
IF SUSER_ID('cwbase200') IS NOT NULL
PRINT '<<< CREATED LOGIN cwbase200 >>>'
ELSE
PRINT '<<< FAILED CREATING LOGIN cwbase200 >>>'
go
USE cwbase200
go
EXEC sp_adduser 'cwbase200','cwbase200','public'
go
IF USER_ID('cwbase200') IS NOT NULL
PRINT '<<< CREATED USER cwbase200 >>>'
ELSE
PRINT '<<< FAILED CREATING USER cwbase200 >>>'
go