Processor Tuning

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  February 20, 2006 at 9:50 pm

  #152776

  Hi Everyone,

  I want to monitor SQL Server-Users :CPU Time but i cant find this counter in the add counter wizard of Performance Monitor.

  How can i monitor this counter.

   

  From

  Killer.

  OS Windows2003

  SQLServer2000 SP4

  4CPU 32 GB RAM

   

• stefano takamatsu gioia-286431

  Valued Member

  Points: 73

  More actions

  February 23, 2006 at 6:14 am

  #622881

  i dont remember exactly by now, but this might help you, dude.

  • run perfmon
  • hit ctrl + i
  • at the field performance object, select sqlserver:memory management
  • there's an option called total server memory and many others

  cya

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  February 24, 2006 at 8:02 am

  #623219

  Dear ,

   

  I know there are number of counters given in the performance counter window.I need to know where i can find the counter written in my question.

   

  Total Server Memory counter is basically used to know how much

  RAM MS-SQL Server is using.This includes total committed buffers in SQL BufferPool and the OS Buffer.

  Or u can say this counter tell how much Dinamic memory SQL Server is consuming.

  Thanx for u help and time.

  From

  Killer