[HELP] Game Server Keep Pausing need Help

[papat1]

Need help my game server keep pausing when there have 40+ players online anyone can help? these sis some error logs from the DB
anyone can help?

here are the some error logs from PSGAME
need any idea how to fix this thank you...

[vovan681]

USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 02/13/2016 23:29:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E FIXED ********.com Twilight ******/

ALTER Proc [dbo].[usp_Insert_Action_Log_E]



@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTimeZ varchar(50),
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS
DECLARE @ActionTime as datetime
SELECT @ActionTime = CONVERT(datetime, @ActionTimeZ, 120)
SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)


IF(LEN(@mm) = 1)
BEGIN
SET @mm = '0' + @mm
END

IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType,
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql,
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint,
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int,
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4

[papat1]

thank you for this script.. i will apply this.. this is a good script with anti dupe thank you so much vovan681.

[papat1]

I NEED HELP AGAIN OF THIS ERROR this is the problem why my server keep pausing and crashing all the time

PS_GAME__system log

2016-02-18 21:52:04 PS_GAME__system log start (Game01) [GERMANY]
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 error mob item drop info load error
2016-02-18 21:52:04 CGameData::InitItemEnchant fopen error
2016-02-18 21:52:05 connect mgr 1168
2016-02-18 21:52:05 Server Version : 50147794
2016-02-18 21:52:05 connect dbagent 1172
2016-02-18 21:52:05 connect gamelog 1184
2016-02-18 21:52:05 Market End -----------------------
2016-02-18 21:52:06 Start CWorldSendThread=5188
Module list:
C:\ShaiyaServer\Server\PSM_Client\Bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08