Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Question Unanswered: Occurrance of deadlocks

    Given 2 servers, identical in schema, same version of ASE, table sizes slightly different but proportional, same indexes, same query plans.
    10,000 transactions send to one server.
    30,000 transactions send to another server.
    It was observed that the types of deadlocks that appeared on the 2 databases differ very much.

    It should be proportional....based on the probablility theory, given such large sample size....

    Any one got any idea?

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Too much parameters (size of the caches, allocation/fragmentation of the pages, index statistics, choices of the optimizer, etc) are influencing an ASE to apply such theoritical rules.

Posting Permissions

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