论坛 › Sybase › sybase 扩大number of open indexes问题

hellovole 发表于 2011-01-07 12:05

sybase 扩大number of open indexes问题

建表和索引的时候 报 Cannot find an available index descriptor for an index. Increase the value of 'number of open indexes'. If sp_configure fails due to lack of index descriptors, edit the configuration file and restart the server


我就增加索引运行下面的语句报错
1> execute sp_configure "number of open objects",5000
2> execute sp_configure "number of open indexes",5000
3> go
Msg 8424, Level 17, State 1:
Procedure 'sp_configure', Line 462:
Cannot find an available index descriptor for an index. Increase the value of
'number of open indexes'. If sp_configure fails due to lack of index
descriptors, edit the configuration file and restart the server.
Msg 8424, Level 17, State 1:
Procedure 'sp_configure', Line 462:
Cannot find an available index descriptor for an index. Increase the value of
'number of open indexes'. If sp_configure fails due to lack of index
descriptors, edit the configuration file and restart the server.
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 462:
master.dbo.spt_values not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 894:
#configure_temp not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 916:
#configure_temp not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 918:
#configure_temp not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
(return status = -7)
Msg 8424, Level 17, State 1:
Procedure 'sp_configure', Line 462:
Cannot find an available index descriptor for an index. Increase the value of
'number of open indexes'. If sp_configure fails due to lack of index
descriptors, edit the configuration file and restart the server.
Msg 8424, Level 17, State 1:
Procedure 'sp_configure', Line 462:
Cannot find an available index descriptor for an index. Increase the value of
'number of open indexes'. If sp_configure fails due to lack of index
descriptors, edit the configuration file and restart the server.
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 462:
master.dbo.spt_values not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 894:
#configure_temp not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 916:
#configure_temp not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 1:
Procedure 'sp_configure', Line 918:
#configure_temp not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
(return status = -7)


哪位高手 帮忙解答下~谢谢！

andkylee 发表于 2011-01-07 12:37

注意顺序
1> execute sp_configure "number of open objects",5000
2> execute sp_configure "number of open indexes",5000
3> go

----------------------------------------------------------

先执行这个试试
execute sp_configure "number of open indexes",5000

如果再不行， 修改 servername.cfg配置文件， 然后重启数据库。

hellovole 发表于 2011-01-07 12:39

感谢andkylee！成功了！:emn10:

andkylee 发表于 2011-01-07 14:15

回复 3# hellovole


    哪种方式成功的？

hellovole 发表于 2011-01-07 15:23

重启服务后，就可以扩增了！

查看完整版本: sybase 扩大number of open indexes问题