Eprs_Admin
asked on
SQL Logging
Hi Experts,
I have to create a template with some indicators for our SQL AG Cluster 2014.
We want to measure these indicators and check performance before and after a deployment.
Can you help me to find very important KPI´s to put into my template ?
Now I monitoring these:
What else is important to check ?
I have to create a template with some indicators for our SQL AG Cluster 2014.
We want to measure these indicators and check performance before and after a deployment.
Can you help me to find very important KPI´s to put into my template ?
Now I monitoring these:
Cache Hit Ratio
Page Life Expactency
Parallelism
Memory
CPU Utilization
Fragmentation
Disk IO
Page Life Expactency
Parallelism
Memory
CPU Utilization
Fragmentation
Disk IO
What else is important to check ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, thanks.
ASKER
What do you think are the most 5 important indicators ?
because I want to create my own template and report.
because I want to create my own template and report.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Eprs_Admin, do you still need help with this question?
ASKER
Is it now good to have a high value or bad because the data stays too long in the buffer ?