Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server counters along with thresholds values

Posted on 2015-02-10
5
Medium Priority
?
109 Views
Last Modified: 2015-03-05
Hello Folks,

I need to work on threshold values for SQL Server counters (please find attached .xlsx file here). Could you please assist me in case I can increase threshold values with respect of each counter?

FYI, we are using a tool ('Kaseya') to check performance for each counter and column 'C' i.e. 'Parameter Value' in .xlsx defined by 'Kaseya' by default. For e.g., value in 'C' column is 30000/120000 then 30000 = Warning & 120000 = Critical.

Could you please assist me to increase/decrease threshold values for each counter along with Warning & Critical values & brief description for each counter?

Please note, we have SQL Server 2012, Enterprise Edition (64-bit).

Best Regards,
Mohit Pandit
SQLServer-Counters-List.xlsx
0
Comment
Question by:MohitPandit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 1500 total points
ID: 40604084
Hi,

Check out this:
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

Given how little master is used, some of your counters such as master size and log utilisation seem of little benefit.

Regards
  David
0
 
LVL 5

Author Comment

by:MohitPandit
ID: 40620986
Hi David,

I shall look into it and let you update.

Best Regards
Mohit Pandit
0
 
LVL 5

Author Comment

by:MohitPandit
ID: 40630497
Hi David,

I took a look over it and it looks like description. BTW, it is useful.
But, is it possible to have your inputs for values of counter Or any formula to calculate counter values so that we can define stages for "Warning" and "Critical".

Thanks

Best Regards,
Mohit Pandit
0
 
LVL 35

Expert Comment

by:David Todd
ID: 40631377
Hi,

What you are asking is perhaps better described by running baselines before the system gets into difficulty, and then keep the baseline updated every month or say at least every year. Then there is something to compare a problem set of numbers to.

HTH
  David
0
 
LVL 5

Author Closing Comment

by:MohitPandit
ID: 40647877
Thanks
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question