High Cpu Utilization | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

High Cpu Utilization

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
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.
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 />
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.
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
]]>