谁有用来监控和修改数据库参数的命令
如sp_sysmon sp_monitorconfig sp_configure 等的详细使用说明及使用时应该注意事项和后果的材料。
我这有几本数据库配置方面的书，但是讲的都非常少，有不是很详细。
还有想问一下，这些命令只能在isql -u -p中运行吗？
如果想把执行后的结果保存起来应该怎么办？用isql -sxx -uxx -pxx -ixx>result.txt
行吗？这个命令中-sxx和-ixx代表什么？结果输出到result.txt文件的话，他存在系统的哪个目录下？
---------------------------------------------------------------
sp_sysmon syntax
sp_sysmon "begin_sample"
sp_sysmon { "end_sample" ¦ "hh:mm:ss" } [ , section [ , applmon ] ]
The simplest way to invoke sp_sysmon is to specify a sample interval using "hh:mm:ss". Using both the "begin_sample" and "end_sample" calls, sampling can also cover specific actions or statements. Warning: only a single sp_sysmon session should be run at a time, as multiple concurrent invocations will produce invalid results due to interference.
As the default sp_sysmon output can be voluminous, it can be limited to a specific section by specifying the section parameter as follows (in sp_sysmon output order):
section parameter Resulting sp_sysmon output
kernel Kernel Utilization
wpm Worker Process Management
parallel Parallel Query Management
taskmgmt Task Management
appmgmt Application Management
esp ESP Management
housekeeper Housekeeper Task Activity
monaccess Monitor Access to Executing SQL
xactsum Transaction Profile
xactmgmt Transaction Management
indexmgmt Index Management
mdcache Metadata Cache Management
locks Lock Management
dcache Data Cache Management
pcache Procedure Cache Management
memory Memory Management (note: this is not very useful …)
recovery Recovery Management
diskio Disk I/O Management
netio Network I/O Management
The applmon parameter is valid only when specifying either “appmgmt” or NULL as the section parameter (it is ignored otherwise) :
appl_only CPU, I/O, priority changes, and resource limit violations by application name.
appl_and_login ibid., by application name and login name.
no_appl Skips the application and login section (=default)
(ASE 11.0.x only) sp_sysmon { 1 ¦ 2 ¦ 3 … ¦ 10 } - In ASE 11.0.x, the only parameter is the duration (in minutes) of the sample interval, ranging from 1 to 10.
---------------------------------------------------------------
1、存储过程：http://www.sybase.com.cn/cn/content/goto.jsp?resID=138&page=1
2、开始-》程序-》sybase-》sql advantage
3、
-----------------------------------
-i:inputfile
-o:outputfile
-------------------------------------
下面是一个例子：
isql -Usa -Sdlw -P -i c:\my.sql -o c:\ddd.txt
执行c:\my.sql里面的语句，结果输出到c:\ddd.txt.
如果不写路径，则输出到isql所处的路径下。
---------------------------------------------------------------
sybase的服务器版的安装盘没有sql advantage
sql advantage在客户client安装盘上，
我有11.92版的。
---------------------------------------------------------------
2。sql advantage在客户client安装盘上
3。没错，在这种情况下是不是显示1>的，但一样输sql命令即可
---------------------------------------------------------------
这个问题好像已经解决了。
我认为这样是可以的。