sybase12.5 相关优化命令

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 '>>' ELSE PRINT '>>' go USE cwbase200 go EXEC sp_adduser 'cwbase200','cwbase200','public' go IF USER_ID('cwbase200') IS NOT NULL PRINT '>>' ELSE PRINT '>>' go