SQL Server Performance

High Cpu Utilization

Discussion in 'SQL Server 2005 Replication' started by jsvishal2005, Oct 17, 2006.

  1. jsvishal2005 New Member

    Could anyone help me in finding out why the cpu utilization is very high??

    I have two servers say, Server A , server B. There is a transactional replication going on from server A to B

    There is a table say Table A on server A, which is being replicated to server B.

    I created a trigger insert and update trigger on Table A on server B (i.e. on subscriber). Since then, the CPU utilization for server B is very high 80-90%

    when i used profiler, i could see .whenever replication stored proc for insert or update executes..cpu utilization goes up..

    trigger just insert the updated/inserted rows into some other table.

    Could anyone tell me why the cpu utilization has gone up so much?? i am using sql server 2005

    Does creating triggers on the subscriber cause performance problem ??

    thanx





  2. satya Moderator

    Collect the information using SYSMON & PROFILER during the process.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. madhuottapalam New Member

    Hi Satya,<br /><br />Visal is already saying that he had run the profiler and probably System Monitor too. How would this tip help him.... <img src='/community/emoticons/emotion-1.gif' alt=':)' />. We are expecting more from MVPs like u ..... (my apology) <br /><br />thanks<br />
  4. satya Moderator

    Madhu
    I appreciate your interest in this regard, but don't you think Vishal should give more information about what he can see from Profiler & SYSMON.

    In some cases trigger proves much expensive in having such slow responses, you might try dropping that trigger and see the performance.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. ghemant Moderator

    Hi,

    We were had similar issue a two year ago a highly used transaction tables has trigger for updated/deleted record after droping the trigger we get a good performance boost (on out of that tables used by 120+ concurrent connection 24*7 and 200 transaction / min)


    Regards

    Hemantgiri S. Goswami
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com

Share This Page