深圳智汇创想科技有限公司

001-
001+ 反馈人：王凯
002- 反馈人：王凯
002+ ，erp站点慢sql，执行慢并发高 : CODE:N21275891
003-
003+ Error:11_-2_0_-2146232060
004-
004+ SQL: SELECT TOP 1 a.* FROM dbo.RB_WareHouse_Position (NOLOCK) a JOIN dbo.RB_WareHousePostArea (NOLOCK) b ON a.CustomerID = b.CustomerID AND a.WarehouseID=b.WareHouseID AND a.ID = b.PositionID WHERE a.CustomerID = CustomerID AND a.WarehouseID = WarehouseID AND b.WareHouseAreaID = WareHouseAreaID AND a.IsActive = 1 AND a.PositionState = 1 AND a.PositionCode NOT IN ( 999SHJF999,999GCZF999,888ZFCD888,999YKWJ999,999DBSH999 ) AND a.Volume > Volume AND a.PositionCode>PositionCode ORDER BY a.PositionCode ASC PARAMS:CustomerID = 1 ,WareHouseID = 5312 ,WareHouseAreaID = 458 ,Volume = 7072.000000000000 ,PositionCode = H3311F02 , MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
005- ，erp站点慢sql，执行慢并发高 : CODE:N21275891
006-
007- Error:11_-2_0_-2146232060
008- SQL:
009- SELECT TOP 1
010- a.*
011- FROM dbo.RB_WareHouse_Position (NOLOCK) a
012- JOIN dbo.RB_WareHousePostArea (NOLOCK) b
013- ON a.CustomerID = b.CustomerID
014- AND a.WarehouseID=b.WareHouseID
015- AND a.ID = b.PositionID
016- WHERE a.CustomerID = CustomerID
017- AND a.WarehouseID = WarehouseID
018- AND b.WareHouseAreaID = WareHouseAreaID
019- AND a.IsActive = 1
020- AND a.PositionState = 1
021- AND a.PositionCode NOT IN ( 999SHJF999,999GCZF999,888ZFCD888,999YKWJ999,999DBSH999 )
022- AND a.Volume > Volume
023- AND a.PositionCode>PositionCode
024- ORDER BY a.PositionCode ASC
025-
026- PARAMS:CustomerID = 1 ,WareHouseID = 5312 ,WareHouseAreaID = 458 ,Volume = 7072.000000000000 ,PositionCode = H3311F02 ,
027- MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。

001- <p>
001+ <p>反馈人：王凯</p>
002- 反馈人：王凯
002+ <p>，erp站点慢sql，执行慢并发高 : CODE:N21275891</p>
003- </p>
003+ Error:11_-2_0_-2146232060<br />
004- <p>
004+ SQL:<br /> SELECT TOP 1<br /> a.*<br /> FROM dbo.RB_WareHouse_Position (NOLOCK) a<br /> JOIN dbo.RB_WareHousePostArea (NOLOCK) b<br /> ON a.CustomerID = b.CustomerID<br /> AND a.WarehouseID=b.WareHouseID<br /> AND a.ID = b.PositionID<br /> WHERE a.CustomerID = CustomerID<br /> AND a.WarehouseID = WarehouseID<br /> AND b.WareHouseAreaID = WareHouseAreaID<br /> AND a.IsActive = 1<br /> AND a.PositionState = 1<br /> AND a.PositionCode NOT IN ( 999SHJF999,999GCZF999,888ZFCD888,999YKWJ999,999DBSH999 )<br /> AND a.Volume &gt; Volume<br /> AND a.PositionCode&gt;PositionCode<br /> ORDER BY a.PositionCode ASC <br /><br /> PARAMS:CustomerID = 1 ,WareHouseID = 5312 ,WareHouseAreaID = 458 ,Volume = 7072.000000000000 ,PositionCode = H3311F02 ,<br /> MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
005- ，erp站点慢sql，执行慢并发高 : CODE:N21275891
006- </p>
007- Error:11_-2_0_-2146232060<br />
008- SQL:<br />
009- SELECT TOP 1<br />
010- a.*<br />
011- FROM dbo.RB_WareHouse_Position (NOLOCK) a<br />
012- JOIN dbo.RB_WareHousePostArea (NOLOCK) b<br />
013- ON a.CustomerID = b.CustomerID<br />
014- AND a.WarehouseID=b.WareHouseID<br />
015- AND a.ID = b.PositionID<br />
016- WHERE a.CustomerID = CustomerID<br />
017- AND a.WarehouseID = WarehouseID<br />
018- AND b.WareHouseAreaID = WareHouseAreaID<br />
019- AND a.IsActive = 1<br />
020- AND a.PositionState = 1<br />
021- AND a.PositionCode NOT IN ( 999SHJF999,999GCZF999,888ZFCD888,999YKWJ999,999DBSH999 )<br />
022- AND a.Volume &gt; Volume<br />
023- AND a.PositionCode&gt;PositionCode<br />
024- ORDER BY a.PositionCode ASC <br />
025- <br />
026- PARAMS:CustomerID = 1 ,WareHouseID = 5312 ,WareHouseAreaID = 458 ,Volume = 7072.000000000000 ,PositionCode = H3311F02 ,<br />
027- MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。