question

vivekchandra09 avatar image
vivekchandra09 asked

Error from monitoring tool on SQL Server 2014 box

Notification Type: PROBLEM Service: MSSQL Page Reads Per Sec Host: delta01.domain.local Address: xxx.xx.xx.xxx State: CRITICAL Info: CRITICAL: Page Reads / Sec is 10698.2529266/sec Date/Time: 2016-12-02 06:40:49
sql server 2014
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I would think that you could adjust that alert and adjust it so that it's better suited for your environment. If 10K pages/sec isn't appropriate (meaning it's too low of an alert) adjust it up so that its better suited. If it is appropriate, you'll have to examine the process that is reading that many pages and see if you can tune things to read less pages.
1 Like 1 ·
What's the question?
0 Likes 0 ·
so the question is where to look for and what to do so that these messages no longer appears.
0 Likes 0 ·
What is the name of the monitoring tool, and how is the error message being conveyed to you? How often?
0 Likes 0 ·
Nagios is the name of the monitoring tool. It sends out an email to three people whose email are on the monitoring alert group.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.