Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    40

    Unhappy Unanswered: sybase-MDA installation

    Hi,

    Will therebe any impact in performance of ASE after installation of MDA tables

    Regards,
    prakash

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    No impact just installing it.
    But it has an impact depending on what you switch on for monitoring.
    e.g. sp_configure 'plan text pipe active',1 will impact performance
    The more you switch on the bigger the impact.
    Here are some estimates of impact on performance
    Code:
    All Disabled                  0%
    Monitoring Enabled Only       1.2%
    Server Wait Events Enabled    0.4%
    Process Wait Events           1.1%
    Object Lock Wait Timing       1.4%
    Deadlock Pipe                 2.2%
    Errorlog Pipe                 2.5%
    Object Statistics Enabled    13.0%
    Statement Statistics Enabled 12.3%
    Statement Pipe Enabled       12.5%
    SQL Text Pipe Enabled        14.3%
    Plan Text Pipe Enabled       21.7%

Posting Permissions

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