[Guide][Performance] Lowering ShardManager Count + Lowering Lag + Removing Logs!

[Jangan]

Summary:
Alright, so i have spent over two months of amazing amount of testing, and i have been doing nothing but upgrading performance on the server by a lot of time! Here is one of my guides to lower the lag! i will be releasing a lot like those! Please remember that you might not notice changes if you have less than 800 players online! because these are built for massive servers!

Objective
We going to remove the logging system of the database logs

Results
* ShardManager msgCount value will be lower than 5-10 instead of 9000+!!
* There will be less lag on your server because the shard manager will have better things to do than process logs
* There will be no logs!

Difficulty
Easy

-----------------------------------------------------------
- Please Execute the Following For the changes -
-----------------------------------------------------------

_AddLogChar

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 12/02/2011 11:35:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddLogChar] 
@CharID        int,
@EventID        tinyint,
@Data1        int,
@Data2        int,
@strPos        varchar(64),
@Desc        varchar(128)
as
    declare @len_pos     int
    declare @len_desc    int
    set @len_pos = len(@strPos)
    set @len_desc = len(@Desc)
    if (@len_pos > 0 and @len_desc > 0)
    begin    
        return -1
    end
    else if (@len_pos > 0 and @len_desc = 0)
    begin    
        return -2
    end
    else if (@len_pos = 0 and @len_desc > 0)
    begin    
        return -3
    end
    else
    begin    
        return -4
    end 

_AddLogItems

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 12/02/2011 11:37:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase            : Shard Log  
ALTER  procedure [dbo].[_AddLogItem]  
  @CharID  int,  
  @ItemRefID int,  
  @ItemSerial bigint,  
  @dwData int,  
  @TargetStorage tinyint,  
  @Operation tinyint,  
  @Slot_From tinyint,  
  @Slot_To tinyint,  
  @EventPos varchar(64),  
  @strDesc varchar(128),
  @Gold        bigint            -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ   
  as  
   declare @len_pos int  
   declare @len_desc int  
   set @len_pos = len(@EventPos)  
   set @len_desc = len(@strDesc)  
   if (@len_pos > 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end 

_AddLogSchedule

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogSchedule]    Script Date: 12/02/2011 11:38:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ·Î±× »ðÀÔ ÇÁ·Î½ÃÀú 
ALTER PROCEDURE [dbo].[_AddLogSchedule] 
    @ServerType VARCHAR(124),
    @ServerBodyID INT,            
    @ScheduleDefine VARCHAR(124),
    @ScheduleIdx INT,
    @nType      VARCHAR(10), 
    @OccureTime DATETIME    -- °¢°¢ÀÇ ¸Ó½ÅÀÇ ½Ã°£À» Àû¾îÁØ´Ù.
AS
   return -1 

_AddLogServerEvent

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogServerEvent]    Script Date: 12/02/2011 11:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER    procedure [dbo].[_AddLogServerEvent] 
@ServerEventID        int,
@LogType        tinyint,
@Desc            varchar(128)
as
    declare @len_desc    int
    set @len_desc = len(@Desc)
    if ( @len_desc > 0)
    begin  
        return -1
     end  
   else
    begin  
        return -1
     end 

_AddLogSiegeFortress

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogSiegeFortress]    Script Date: 12/02/2011 11:40:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER    procedure [dbo].[_AddLogSiegeFortress] 
@FortressID        int,
@EventID        tinyint,
@CharID            int,
@Data1            int,
@Data2            int,
@Desc            varchar(128)
as
    declare @len_desc    int
    set @len_desc = len(@Desc)
    if ( @len_desc > 0)
    begin  
        return -1
     end  
   else
    begin  
        return -1
     end 

[MentaL]

[Frezze1]

Nice but i have one question.

After i use this querry, is it possible to use the sr_userlog from smc or will it show me 0 Log's?

Because its importand to bann scammers or hacker

[Jangan]

Depends what kind of logs you are looking for ... but this will disable all items and character logs.

[sladlejrhfpq]

omg... thank you *_*

[TryToMakeServer]

nice one

[Jangan]

Thank you guys, appreciate the replies!

[TryToMakeServer]

Jangan, are you already in a server team?

[Jangan]

I own perfection network
SrStats :: Capacity - Perfection

[TryToMakeServer]

Oj, allright^^

Hey, I've got now 1100 overlap count xD
What to do?^^

[Jangan]

Oj, allright^^

Hey, I've got now 1100 overlap count xD
What to do?^^

upgrade your server... its not processing data fast enough. and upgrade your db!

[TryToMakeServer]

64000 overlap count, no lags ingame.

Is that overlap count necessary?

[Jangan]

very... unless your gameserver counters broke.

i broke the counters lots of times before and

[Chern0byl]

Why not just a procedures constantly returning success value, and doing just nothing ?

[Jangan]

Why not just a procedures constantly returning success value, and doing just nothing ?

i tried that, for a while it worked but idk what it is, but the shard would randomly break.

i think it calls specific functions in the sp.. not sure :S

[Dbays]

Hi First of all Merry Christmas to everyone

im sorry guys but could u tell me where to go in SQL Managment to Execute this code's?