Can SQL queries used monitor SSAS instances be filtered from SQL PI?
An example query is
SELECT TOP 500
SPID,
LOCK_ID,
LOCK_OBJECT_ID,
LOCK_STATUS,
LOCK_TYPE,
LOCK_CREATION_TIME,
LOCK_GRANT_TIME
FROM $SYSTEM.DISCOVER_LOCKS
WHERE (LOCK_GRANT_TIME > 1498487452043
and LOCK_GRANT_TIME > LOCK_CREATION_TIME)
or LOCK_GRANT_TIME=0
The following groovy script can be used to filter Analysis Services Performance Investigator related queries.
import com.quest.nitro.service.sl.interfaces.config.*
agentName = ""
maxRows = "300";
agentService = server.get("AgentService");
configService = server.get("ConfigService");
def getAgentByName(agentName) {
agents = agentService.findByName(agentName);
if ((agents != null) && (agents.size() > 0)) {
return agents.get(0);
} else {
return null;
}
}
def modifyAgentProperty(agent,filter) {
agent=getAgentByName(agentName)
if (agent == null)
return;
def namespace = agent.getAgentNamespace();
def agentType = agent.getTypeId();
def asp = configService.getAgentInstancePrimaryAsp(namespace, agentType, agent.getId())
asp.setValueByString("ssasSpiEngOlapSampleFilterSampler",filter);
configService.saveConfig(asp);
println(asp.getBoolean("ssasSpiEngOlapSampleFilterSampler"));
}
def agent;
modifyAgentProperty(agent,"true")
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center