Memory and CPU Paging

• aryelik

  Newbie

  Points: 1

  More actions

  January 15, 2003 at 7:47 am

  #58248

  I have a SQLServer running in a 1.4 GB memory and Pentium 3 processor. Whenever the allocated maximum memory is reached, a 100% CPU utilization occurs. Do I have to upgrade to higher CPU or there's some tuning that I can do to resolve this problem?

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  January 15, 2003 at 9:11 am

  #446383

  Use performance monitor to monitor following counters.

  memory : pages/sec

  processor : %processor time

  physical disk : ave disk queue length

  sql server : memory manager : total server memory

  The issue may be related to lack of sufficient memory and slow disk I/O too.

  Please also provide hardware and disks configuration information, as well as SQL server.