1

I'm still learning a lot about SQL Server and pretty green, but doing the best I can as an accidental DBA.

We have recently purchased a SQL monitoring software package, and after adjusting the threshold on alerting so I'm not bombarded with false positive warnings, I noticed that the pages input per second spikes every day at exactly the same time: 6:20:30 PM. The only variation in time over the last week was just last night, when it alerted again at 6:19:39 PM.... very very close to the same time!

I have checked the server job schedules and it appears there are no jobs scheduled around that time. The earliest job we have kicking off is at 9pm daily, so that's not it.

Can anyone tell me what I can look at (or for) that will help me find what is causing this to happen at exactly the same time every day?

Thanks much!

Improve this question
2

1 Answer 1

Reset to default
1

It is OS performance counter and refers to reads of page file. Generally it points to low memory condition on server. With your provided info no specification can be made about the issue. You need to monitor the server processes at that time. Also have a look at other applications consumption if exist on same server along with SQL Server.

Improve this answer
2
  • Thank you for your reply. When you say to "monitor the server processes at that time", can you please elaborate on this? I'm not sure what process or types of processes I should be looking for, or how to monitor them since our office closes at 4:30pm and this doesn't happen until 6:20pm. Just not quite sure what I'm looking for or where to look for it. Thanks much.
    – Isaac A.
    Commented Nov 14, 2018 at 15:20
  • You would have to schedule a job that can capture and save the results of sp_who2 or preferable sp_whoisactive (it is not a system SP. Can be downloaded and created on server). Else u can configure a trace to capture the activity. Make sure to follow the best practices for traces to avoid load on server.
    – DBDigger
    Commented Nov 15, 2018 at 14:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.