Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server counters along with thresholds values

Posted on 2015-02-10
5
Medium Priority
?
113 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 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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 to return specific rows and columns, with various degrees of sorting and limits in place.

877 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