Resource pool stats in SQL server -
for project purposes , i've configured alert in sql server object resource pool stats , counter cpu usage target %. when usage target % rises above configured threshold , i'm invoking job capture cpu expensive queries running @ point of time. counter cpu usage target % basically? cpu usage sql server service alone or cpu usage other windows processes well. tried simulating cpu loads identify counter purpose couldn't succeed i'm unable generate significant cpu load observations. kindly me in understanding science of counter in sql server.
Comments
Post a Comment