Cached crashed problem[deadlock or super-lag detected]

Discussion in 'Discussions & Suggestions' started by sandeagle, Nov 7, 2019.

  1. sandeagle

    sandeagle Member

    In recent days, my server often has various problems of hanging cached.i dont know why,and i found in Cached there are lots sql procedure execute records...some sql procedure execute overtime.There will be a delay problem in a few hours or so. Players will get lag in game,and then Cached will Crash later.
    any hints?

    [​IMG]
    [​IMG]
     
  2. ProtossMG

    ProtossMG New Member

    Hello,
    What is the build date of your l2server and cached dlls?
    and about version of your sqlserver and windows?
    Show your databse files and general tabs over lin2world properties > https://prnt.sc/pu0thv
     
    Last edited: Nov 8, 2019
  3. sandeagle

    sandeagle Member

    l2server and Cached dlls build date is 2019.8.3
    i used 2008 server and sql 2005 enterpirce.

    [​IMG]
     
  4. ProtossMG

    ProtossMG New Member

  5. sandeagle

    sandeagle Member

    thx dude,i had found the cause of the problem.my harddisk broken...
    thank you for your help.
     
  6. sandeagle

    sandeagle Member

    god damn it....problem still accured...


    [​IMG]
     
  7. ProtossMG

    ProtossMG New Member

    let me see your files menu
     
  8. Xeonc

    Xeonc Administrator

    Image is not available
     
  9. sandeagle

    sandeagle Member

    thx admin...you are right ,its my Memory problem.i extended my memory to 24G,this problem solved...\
    : )