SQL Server Performance

12 memory pages/sec spikes per day?

Discussion in 'General DBA Questions' started by brimba, Oct 24, 2005.

  1. brimba New Member

    Hello!<br /><br />When I run perfmon with an update of 900 seconds, wich then lasts for 1 day and 1 hour. I will get 12 spikes. One every other hour of the pages/sec.<br /><br />I have scripts that runs every hour, but not every other hour. Anyone have an idea of what SQL-Server could be doing?<br /><br /><img src='' border='0' /><br /><br />During 25 hours the pages/sec will have this statistics<br /><br />Avg: 62<br />Max: 4556
  2. Chappy New Member

    Impossible to say just from this info you give us

    Run SQL Profiler and see what acitivty is occurring
  3. brimba New Member

    Ok. I just thought this was some "normal" stuff, but ok, I will go for profiler.

  4. satya Moderator

    Can you check what was the time interval & scale chose on the PERFMON.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. brimba New Member

  6. brimba New Member

    I could not find anything that should cause the pages/sec spike with profiler.

    Any suggestions of how I should move on?
  7. Chappy New Member

    Are there any other apps on that machine running alongside sql server ?

    Are there any jobs running once an hour? Log shipping?
  8. brimba New Member

    Nope, no other apps.

    But I found it.

    I missed by mistake that fulltext incremental build were running every other hour.

    Thank you!

Share This Page