HP-UX ASE12.5.3 经常down

yyhll

多谢楼上的热情回答。

chinage

提醒一下，如果用HP，即使操作系统打开了异步，'allow sql server async i/o'也设为1（确省就是1），但是你用文件系统而不用裸设备的话，仍然用不上异步

yyhll

在网上查了一下，有类似的问题，这是链接：
http://dbforums.com/t483629.html

在这里贴一下：


In <B991327B.3026%eriosj@televisa.com.mx> Gary Rios Jacques wrote:
  > Hi guys Im running an ASE -12 on Hp-UX 11 Running 4 engines and this week I got
  > this error Failed to open virtual socket for new connections
  > 03:00000:00040:2002/08/27 11:41:14.27 kernel nopen: accept, No buffer space
  > available I checked the cnsocket values by dbcc resource and
  > I got Cnsocket=582 I have checked the max_connection value
  > and I got 8152 Number of user connections are 550 and I have
  > 20 in remote connections So 550+20+3 I have 563 below to
  > the 582 Does anybody could send me a hand Thanks in advanced

Hi Gary,

Don't forget the "number of devices"... this too is part of cnsockets. Recommendation
is to increase # user connections to 650 or so.