long running queries -
07-08-2004
, 01:16 PM
Is there a way to list and/or kill long running queries within MSAS?
Alternately, is there a way to limit the time MSAS will spend on a
particular query?
One client's server is experiencing periodic slow-downs (30 sec queries
turn into 8 minute queries) and I'd like to find a way to list what MSAS
is doing to see if there are any rogue queries sapping CPU/memory. |