MEMUSAGE:
This is useful for validation your SQLserver memory configuration, dbcc
memusage reports three pieces of information.
The current allocation of memory within SQL server
Up to the 20 largest tables and or index currently in datacache.
Up to the 20 largest sored procs currently in procedure cache.
Examble for the code.
dbcc traceon (3604)
go
dbcc memusage
go
SP_SYSMON:
Sp_symon is a specialized system proc used to produce a statically report on the
sql server it will provide an overall performance picture for the adaptive
server(ASE) it is run on it will only work on system 11 and above.
The sytax for it is as followed
Sp_sysmon interval , section , applmon
The interval should be entered in “hh:mm:ss” format
It is not wise to run this on a daily basis as the system over head is to great this is
used for spot checks to see how the system is running. And example is to run
Sp_sysmon “00:15:00”
No comments:
Post a Comment