Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Posts
    9

    Unanswered: Data Update Problem

    Dear All,
    I am facing a problem from last one month. I have around 100 of client user of my database. I am using VB application for the client users. When they submit the information most of the time the information submits properly. But twice or thrice a day no one can submit the information properly. It remains for more then 15 mins and it will sort out automatically.
    What might be the problem. Please suggest

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Database locking?

    Without more information, we can't really help you.

    When this happens again, check to see if any blocking is occuring.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jul 2005
    Posts
    9

    More Info

    I am trying to trace from the Profiler. All the Insert statement to that particular table is taking a lot of time. At that point of time the cpu usases, memory everything is ok.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    did you sp_who2 or sp_lock?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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