Using DMVs to Monitor and Terminate Long Running MDX Queries

At one time or other, just about every DBA charged with administering a Microsoft SQL Server Analysis Services server has encountered a long running query that seems to consume machine resources with a voracious appetite. Those queries are typically executed by “Power Users” and almost invariably at a time that other users are attempting to…

0