sql@100%

  • hi,

      I am trying to play with other options to find why the cpu goes to 100%. As far as this table that i set fill factor of 70 has index key on datetime and timestamp.  This table has heavy inserts..  I am not sure if I am asking right question but it would help where else should I check so the cpu does not go up 100%..

     

     

  • Hi all....

    The above methods wats mentioned are good in finding out the CPU utilization.Can anyone advice me how i can monitor all the processes consuming CPU usage continuously (by the use of some job scheduled to execute a procedure which determines the CPU usage)and can keep some threshold like 70% and if CPU usage crosses that threshold I should be able to get an alert.

    Thanks in Advance...

    Vinay

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply