Solved

SQL Server counters along with thresholds values

Posted on 2015-02-10
5
91 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now