We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x
Private

Im looking for a way to improve my SCOM interpretation.

Medium Priority
174 Views
Last Modified: 2020-03-30
Im looking for a way to improve my SCOM interpretation.  For example, the alert  "SQLServer BufferManager PageLifeExpectancy Monitor Resolution state" "Counter Page life expectancy
Has a value 227"  I learned over time that this means that someone is querying the database, and their query is very slow or not returning results.

Is there a less technical place to learn this skill?  I am not a scom specialist, but I am a server manager/Sys Admin and do need to know this.

Thank you much,
Mark
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Below would be a good start to understand the SQL Server related perfmon counters..
https://www.polymorphe.org/index.php/303-sql-server-performance-counter-poster/file

Couldn't get the explanation for all windows counters, but this one covers all the important ones..
http://www.appadmintools.com/documents/windows-performance-counters-explained/
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Hi Raja,
These are great, thank you very much!
I'll leave this open a week or so in case anyone else joins the discussion.
Thank you,
Mark
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Sure, let me know if you need more details..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Raja,
Im getting spammed with this one, and it's not on the sheet above.

Alert: Free & Zero Page List Bytes
Source: DB01
Path: Not Present
Last modified by: System
Last modified time: 2/26/2019 1:36:52 PM
Severity: 2: (2=Critical; 1=Warning)
Alert description: Instance
            Object Memory
            Counter Free & Zero Page List Bytes
            Has a value 94437376
            At time 2019-02-26T13:36:52.0000000-05:00
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> Counter Free & Zero Page List Bytes Has a value 94437376

This counter can be measured as part of the \Memory\Available Bytes counter in the link I've shared..
If the free memory is less than 5 or 10%, then we need to identify the free memory available and the reason behind that..

May I know what is the RAM available in your server and what is the free memory available in the Server now, seems like the counter value says only 90 MB free memory available and hence you are getting lot of alerts.
If you have SQL Server installed in that machine, kindly confirm whether you have configured Max Server Memory or not..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Thank you.  Checking...
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
TOTAL is DB 1 and 2 have 96 GB of RAM, and the RDW has 48 GB.  AVAILABLE IS: db1 has 4 gig, db2 has 8gig, and the rdw has 4.5
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> TOTAL is DB 1 and 2 have 96 GB of RAM, and the RDW has 48 GB.  AVAILABLE IS: db1 has 4 gig, db2 has 8gig

Can you kindly clarify on whether you have 2 DB Servers each have 96 GB of RAM allocated or both together has 96 GB allocated.
If so, kindly let me know how the free space of 4 GB and 8 GB are identified for DB1 and DB2..
Also request you to confirm whether you have restricted the Memory usage of SQL Server by configuring the Max Server Memory values or not..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Yes, the 2 DB's each have 96.  
I need direction on how to find out in SQL how much it is set to take, and how to confirm whether you have restricted the Memory usage of SQL Server by configuring the Max Server Memory values or not..
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
To verify whether Max Server Memory is configured or not, kindly do the below steps:
1. In SSMS, connect to your SQL Server instance.
2. Right click on the Server and choose Properties
3. Click on Memory in Left Pane and check whether Max Server Memory value is configured or not.. By Default it would be 2 TB and we need to make sure that it is configured with let's say 84 GB or 88 GB leaving remaining memory for OS and other operations.
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
How do I, "Right click on the Server and choose Properties"?  when in SSMS, I just see the left pane.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
On the Left pane, right click the Server name or IP which you have connected and then Choose properties and then proceed to the next steps..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
can you please get a screenshot off of the internet and circle what you're trying to do please?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Maximum server memory in MB is 83170
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Hi Mark,

Thanks, seems the Max Server Memory is restricted or configured to use only 81.3 GB then the remaining RAM would be used for OS and other operations.
If you are receiving alerts about free memory less than 93 MB, then you should concentrate on the Services or applications that are using around 15 GB of RAM and decide whether it is normal or not.
If normal, then we need to reduce the Max Server Memory of SQL Server to let's say 75/79 GB so that the other services can perform better.
Hope this helps..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
New issue Raja....
Im not finding many of our scoms on the two resources you gave me.  Do you know why that is?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
All SQL Server related counters will be available on Servers which have SQL Server installed out..
If you don't have SQL Server installed on those 2 SCOM's, then you wouldn't be able to find out those perform counters on those machines.
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
when I take a part of the scom and copy paste it to search those two documents rarely do I really get a match
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
May I know the list of parameters you aren't getting a match to verify once from my end..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Alert description: The resource pool All Management Servers Resource Pool failed to heartbeat.  And many others.  As I see them come in, I will post
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Kindly check whether the below links are of any help to you or not..
http://operationsmanager2012.blogspot.com/2012/12/all-management-servers-resource-pool.html
Please find the tweaking of SCOM agents a little bit here..
https://kevinholman.com/2014/06/25/tweaking-scom-2012-management-servers-for-large-environments/
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
ok. I will check these.  Thank you much
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Any other ideas come to mind?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Can you please clarify on the list of things you have tried and the current state where you are in so that I can suggest further..
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Most of the scom emails are not found anywhere in the resources you sent.
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Hi
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
>> Most of the scom emails are not found anywhere in the resources you sent

Kindly request you to be more clear on what exactly you need for SCOM so that I will try to provide it accordingly..

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Ok, stand by
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
t thank you
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.