Solved

SQL Server counters along with thresholds values

Posted on 2015-02-10
5
96 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
  • 3
  • 2
5 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

820 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