Memory issue

• sudarram

  SSChasing Mays

  Points: 623

  More actions

  March 16, 2009 at 1:05 am

  #95280

  Hi all,

  While monitoring the server i saw that the CPU usage of the Server is high and the SQLSERVER is using some 142,268K [which is high among the other processes].As a DBA what should be my first step to solve this?

  What is did is i cheked the column CPU in sysprocesses.Is that in MB or Bytes?

  Please help me in knowing a lot about this issue

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  March 16, 2009 at 1:17 am

  #960064

  Column cpu in sysprocesses show the cpu time taken for a particular process (spid). Its in milliseconds.

  "Keep Trying"