Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2011
    Posts
    3

    Question Unanswered: Tables getting blocked

    Hello All,

    We are using Sql Server 2000 with peoplesoft Application.From a few days many of the tables are getting blocked(LOCKED) and no user is able to access the application during that time.Please provide some solution.

    Thanks and Regards,
    Ajith

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Quote Originally Posted by ajithkn View Post
    Hello All,

    We are using Sql Server 2000 with peoplesoft Application.
    Sounds dreadful.

    Have you captured what processes are doing the blocking? sp_who2 'active'. DBCC INPUTBUFFER, DBCC OPENTRAN and all of that jazz.

    An experienced SQL Server developer with version 2000 experience probably needs to help you loosen up your concurrency and your isolation levels if your system can handle that and make your SQL and database structured efficient and faster.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jul 2011
    Posts
    3
    ThankYou Thrasymachus for the reply,


    Yes we have tried sp_who2 active and other stuffs.But many a times it shows a peculiar user kworldreader along with sa but that user is not familiar at all.Also is there any solution or tools which can help in sql server 2000 efficiency??

    Thanks in advance..

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What PeopleSoft version (for PeopleTools and each application) are you running? That makes a huge difference in how you approach this kind of problem.

    At least form my perspective, the biggest problem that you have is that you don't know what problem you have... This doesn't mean that you've done anything wrong, but it means that you don't really understand your environement and that can be extremely dangerous with any ERP system.

    Knowing what the kworldreader spid is doing would help a lot. kworldreader is a SQL login used by DVB (Digital Video Broadcasting) management software, so if your users are using DVB hardware with a sequence/streamedit database on the same SQL instance as your PeopleSoft database(s) then I would start with that software and those users.

    I can give you a query that will show more insight into the problem. I also have a query that will use brute force to make the SQL Server responsive again, but this will usually wreak havok if you don't know exactly what caused your problem.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Jul 2011
    Posts
    3
    We are using peoplesoft 8.8 with PT 845.Thanks for your reply now we have done some archival of data and removed some of the access for db..we are monitoring the scenario now and lets see and hope the problem solves...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •