Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Cool Unanswered: Weak performance and SQL-Server Hang-Ups

    Greetings everybody,

    lately we are experiencing some very strange behaviour on the part of our
    SQL-Server.

    We are using SQL-Server as a combined Database for one COM+ application and one J2EE-Application. All of this is installed on the same machine (dual-CPU, 2 GB RAM).

    This setup has been up and running for almost a year now.

    In the last two weeks there have been incidences where the performance of SQL-Server is decreasing steadily until it finally hangs completely (just SQL-Server, not the machine itself).

    This happens 2-3 times a week, curiously always between 9 and 10 a.m.!

    After stopping and restarting the actual SQL-Server "Service", everything is back to normal (until the next morning or the morning after that).

    There are a few automated batches that access the database via the COM+ Server. These run at night and are completed before work begins at ca. 7 a.m.

    Profiler-Logs show a few "Escalate Locks", but those alone cannot account for this strange behaviour.

    Any help or info would be greatly appreciated.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Actually excessiving locks can max out your CPU's and even make the server inaccessible. Any AV's in your error log?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Actually excessive locks can max out your CPU's and even make the server inaccessible. Any AV's in your error log?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Dec 2004
    Posts
    2
    Thanks for your quick response.

    Please forgive me if i seem ignorant, but what do You mean by "AVs"

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by linckh
    Thanks for your quick response.

    Please forgive me if i seem ignorant, but what do You mean by "AVs"
    I think an AV is an Access Violation.

    -PatP

Posting Permissions

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