asked on

SQL Server counters along with thresholds values

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

ASKER CERTIFIED SOLUTION

David Todd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MohitPandit

ASKER

Hi David,

I shall look into it and let you update.

Best Regards
Mohit Pandit

MohitPandit

ASKER

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

David Todd

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

MohitPandit

ASKER

Thanks