How to kill running query?

Hi!
Our users often run malicious queries which could take up to quarter of CPU power for couple of hours. If there is more that one such query, the whole environment is severely impacted with no other recovery that restarting the service.

Is there any (easy) way how to kill unwanted connections and related queries? If not, could someone please give some explanation for that (is it design issue or what?). Otherwise I'd like to see that functionality in SP2-3. Someone with similar experience out there?Could you tell us please, what a client do you use?|||The mechanism of cancelling queries in Yukon is based on establishing another connection with the server passing the same session id as part of the connection string. If that session is currently executing a query it is possible to send query cancel request. Microsoft.AnalysisServices.Server class has CancelCommand method, for instance.

To determine which sessions are running it is possible to send sessions discover schema request.

I am not sure how you are planning to do it - automatically or manually.|||

Could own Command be cancelled without AMO. Only using AdomMd.NET?

What a XMLA Execute schould be ussued?

Who has permittion to cancel command in another session?

|||

Absolutly.

You can use any client, not only AMO to send a Cancel command.

For instance, you can use ActivityViewer sample application to cancel user sessions, or user connections.

Connect to Analysis Server with Profiler to see exact syntax of the Cancel command. Then you can use any client object model to submit the command.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Just a few days ago, we discovered that when a user cancels his or her query from Excel (that's our front end to our AS2005 cube), it's only canceling on the client side and that the query is still running on the server and will keep on running until it completes (yes, "canceling" takes just as long as if the user had let the query run until completion). As a result, our server's memory and CPU gets consumed entirely and requires us to restart the service at least once or twice a day.

I believe if one cancels a query from within Management Studio, the query will also not be canceled immediately and will essentially run to completion.

Basically, we discovered that canceling is simply asking for the results to not be shown as the query will still run to completion.

Is there a way we can kill the query when the user hits escape in Excel?|||

For Excel case this needs to be investigated. If this is not about Office 12 Beta Excel then the client probably executes the queries on non user interface thread and when user tries to cancel the query the client simply unblocks the UI thread, while the worker thread keeps running.

In SQL Server Management Studio we do not do that. We send Cancel request to the server, server notices it and as soon as algorithms are ready to break the server produces "query cancelled" response. If for some queries the server does not break reasonably soon then this should be logged as a bug.

|||Thank you, Edward! I complied ActivityViewer and it is what I was looking for.

Personally I think this is very important feature and it should be internal part of Management Studio, the same way as SQL has Activity Monitor. But at least there's a way how you can do it.

Cheers!
Radim|||UPDATE:

Using Excel 2003 SP2, I connected to a local AS2005 cube. I wrote a report and saved it. I opened up the workbook and hit "refresh data". After a few minutes, the query is done. I then went into view the code of the sheet so I could get the MDX. Using activesheet.pivottable.mdx, I got the following query:

SELECT NON EMPTY CROSSJOIN(CROSSJOIN(CROSSJOIN(HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({[Customer].[Customer Id].[All]})})), HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({[Customer].[Customer Name].[All]})}))), HIERARCHIZE(Except({AddCalculatedMembers(Except({AddCalculatedMembers(DrillDownLevel({[Customer].[Region Code].[All]}))}, {[Customer].[Region Code].&[ZUG], [Customer].[Region Code].&[ZRCH], [Customer].[Region Code].&[ZHJG], [Customer].[Region Code].&[ZDHD], [Customer].[Region Code].&[ZAC], [Customer].[Region Code].&[YUNN], [Customer].[Region Code].&[WYO], [Customer].[Region Code].&[WY], [Customer].[Region Code].&[WV], [Customer].[Region Code].&[WTRF], [Customer].[Region Code].&[WSX], [Customer].[Region Code].&[WRW], [Customer].[Region Code].&[WRSW], [Customer].[Region Code].&[WOR], [Customer].[Region Code].&[WMD], [Customer].[Region Code].&[WISL], [Customer].[Region Code].&[WIL], [Customer].[Region Code].&[WI], [Customer].[Region Code].&[WFLN], [Customer].[Region Code].&[WBNG], [Customer]
.[Region Code].&[WA], [Customer].[Region Code].&[VT], [Customer].[Region Code].&[VRLB], [Customer].[Region Code].&[VNTO], [Customer].[Region Code].&[VNNA], [Customer].[Region Code].&[VLNC], [Customer].[Region Code].&[VJLE], [Customer].[Region Code].&[VIC], [Customer].[Region Code].&[VI], [Customer].[Region Code].&[VEST], [Customer].[Region Code].&[VER], [Customer].[Region Code].&[VA], [Customer].[Region Code].&[UTRC], [Customer].[Region Code].&[UT], [Customer].[Region Code].&[USMA], [Customer].[Region Code].&[UPPS], [Customer].[Region Code].&[ULPR], [Customer].[Region Code].&[TYRO], [Customer].[Region Code].&[TYN], [Customer].[Region Code].&[TX], [Customer].[Region Code].&[TSCA], [Customer].[Region Code].&[TORF], [Customer].[Region Code].&[TOKY], [Customer].[Region Code].&[TNDU], [Customer].[Region Code].&[TN], [Customer].[Region Code].&[TLAX], [Customer].[Region Code].&[TIPN], [Customer].[Region Code].&[TIAN], [Customer].[Region Code].&[THUR], [Customer].[Region Code].&[TAMS], [Customer].[Region Code].&[TA]
, [Customer].[Region Code].&[SYO], [Customer].[Region Code].&[SXNY], [Customer].[Region Code].&[SXAN], [Customer].[Region Code].&[SUR], [Customer].[Region Code].&[SUF], [Customer].[Region Code].&[STKH], [Customer].[Region Code].&[STIR], [Customer].[Region Code].&[STA], [Customer].[Region Code].&[SP], [Customer].[Region Code].&[SON], [Customer].[Region Code].&[SOM], [Customer].[Region Code].&[SNDJ], [Customer].[Region Code].&[SLTH], [Customer].[Region Code].&[SLP], [Customer].[Region Code].&[SLG], [Customer].[Region Code].&[SK], [Customer].[Region Code].&[SICH], [Customer].[Region Code].&[SHR], [Customer].[Region Code].&[SHNG], [Customer].[Region Code].&[SHND], [Customer].[Region Code].&[SEOU], [Customer].[Region Code].&[SELA], [Customer].[Region Code].&[SD], [Customer].[Region Code].&[SCRZ], [Customer].[Region Code].&[SCLA], [Customer].[Region Code].&[SCHH], [Customer].[Region Code].&[SCBO], [Customer].[Region Code].&[SC], [Customer].[Region Code].&[SARA], [Customer].[Region Code].&[SAAR], [Customer].[Region
Code].&[RSCM], [Customer].[Region Code].&[RNAL], [Customer].[Region Code].&[RI], [Customer].[Region Code].&[RHPF], [Customer].[Region Code].&[RGLN], [Customer].[Region Code].&[RENF], [Customer].[Region Code].&[QRO], [Customer].[Region Code].&[QR], [Customer].[Region Code].&[QLD], [Customer].[Region Code].&[QC], [Customer].[Region Code].&[PULA], [Customer].[Region Code].&[PUE], [Customer].[Region Code].&[PTCH], [Customer].[Region Code].&[PRTO], [Customer].[Region Code].&[PRHV], [Customer].[Region Code].&[PR], [Customer].[Region Code].&[POW], [Customer].[Region Code].&[PNDC], [Customer].[Region Code].&[PLPN], [Customer].[Region Code].&[PIEM], [Customer].[Region Code].&[PGLA], [Customer].[Region Code].&[PEMB], [Customer].[Region Code].&[PE], [Customer].[Region Code].&[PDLL], [Customer].[Region Code].&[PCRD], [Customer].[Region Code].&[PACD], [Customer].[Region Code].&[PA], [Customer].[Region Code].&[OXO], [Customer].[Region Code].&[OVJS], [Customer].[Region Code].&[OTH], [Customer].[Region Code].&[OSLO], [Cust
omer].[Region Code].&[ON], [Customer].[Region Code].&[OK], [Customer].[Region Code].&[OH], [Customer].[Region Code].&[OBER], [Customer].[Region Code].&[OAX], [Customer].[Region Code].&[NYO], [Customer].[Region Code].&[NY], [Customer].[Region Code].&[NXI], [Customer].[Region Code].&[NVRA], [Customer].[Region Code].&[NV], [Customer].[Region Code].&[NSW], [Customer].[Region Code].&[NS], [Customer].[Region Code].&[NRW], [Customer].[Region Code].&[NRDH], [Customer].[Region Code].&[NRDB], [Customer].[Region Code].&[NPDC], [Customer].[Region Code].&[NOT], [Customer].[Region Code].&[NOR], [Customer].[Region Code].&[NMR], [Customer].[Region Code].&[NMP], [Customer].[Region Code].&[NM], [Customer].[Region Code].&[NL], [Customer].[Region Code].&[NJ], [Customer].[Region Code].&[NH], [Customer].[Region Code].&[NGR], [Customer].[Region Code].&[NF], [Customer].[Region Code].&[NEL], [Customer].[Region Code].&[NEID], [Customer].[Region Code].&[NE], [Customer].[Region Code].&[ND], [Customer].[Region Code].&[NC], [Customer].[R
egion Code].&[NBL], [Customer].[Region Code].&[NB], [Customer].[Region Code].&[MWP], [Customer].[Region Code].&[MTH], [Customer].[Region Code].&[MT], [Customer].[Region Code].&[MS], [Customer].[Region Code].&[MRCA], [Customer].[Region Code].&[MPY], [Customer].[Region Code].&[MOR], [Customer].[Region Code].&, [Customer].[Region Code].&[MNGN], [Customer].[Region Code].&[MN], [Customer].[Region Code].&[MLO], [Customer].[Region Code].&[MI], [Customer].[Region Code].&[MHRS], [Customer].[Region Code].&[MEX], [Customer].[Region Code].&[METR], [Customer].[Region Code].&[MER], [Customer].[Region Code].&[ME], [Customer].[Region Code].&[MDX], [Customer].[Region Code].&[MDRD], [Customer].[Region Code].&[MD], [Customer].[Region Code].&[MB], [Customer].[Region Code].&[MAYO], [Customer].[Region Code].&[MALM], [Customer].[Region Code].&[MA], [Customer].[Region Code].&[LWSX], [Customer].[Region Code].&[LTH], [Customer].[Region Code].&[LSBO], [Customer].[Region Code].&[LPZ], [Customer].[Region Code].&[LOND], [Customer].[R
egion Code].&[LODZ], [Customer].[Region Code].&[LMSN], [Customer].[Region Code].&[LMCK], [Customer].[Region Code].&[LMBR], [Customer].[Region Code].&[LMBD], [Customer].[Region Code].&[LINC], [Customer].[Region Code].&[LIMB], [Customer].[Region Code].&[LIMA], [Customer].[Region Code].&[LIGE], [Customer].[Region Code].&[LGRA], [Customer].[Region Code].&[LEI], [Customer].[Region Code].&[LAZO], [Customer].[Region Code].&[LAR], [Customer].[Region Code].&[LAN], [Customer].[Region Code].&[LA], [Customer].[Region Code].&[KYON], [Customer].[Region Code].&[KY], [Customer].[Region Code].&[KS], [Customer].[Region Code].&[KRLA], [Customer].[Region Code].&[KLK], [Customer].[Region Code].&[KLD], [Customer].[Region Code].&[KEN], [Customer].[Region Code].&[KELA], [Customer].[Region Code].&[JONK], [Customer].[Region Code].&[JOHO], [Customer].[Region Code].&[JNGS], [Customer].[Region Code].&[JHCS], [Customer].[Region Code].&[JAL], [Customer].[Region Code].&[IZMR], [Customer].[Region Code].&[ISTN], [Customer].[Region Code].&[IS
LE], [Customer].[Region Code].&[IN], [Customer].[Region Code].&[IL], [Customer].[Region Code].&[IDF], [Customer].[Region Code].&[ID], [Customer].[Region Code].&[IA], [Customer].[Region Code].&[HUNN], [Customer].[Region Code].&[HSSN], [Customer].[Region Code].&[HNUT], [Customer].[Region Code].&[HNN], [Customer].[Region Code].&[HN], [Customer].[Region Code].&[HMBG], [Customer].[Region Code].&[HI], [Customer].[Region Code].&[HGO], [Customer].[Region Code].&[HER], [Customer].[Region Code].&[HDLN], [Customer].[Region Code].&[HBEI], [Customer].[Region Code].&[HB], [Customer].[Region Code].&[HAW], [Customer].[Region Code].&[HAM], [Customer].[Region Code].&[GU], [Customer].[Region Code].&[GTO], [Customer].[Region Code].&[GRON], [Customer].[Region Code].&[GRLO], [Customer].[Region Code].&[GRCC], [Customer].[Region Code].&[GNGD], [Customer].[Region Code].&[GM], [Customer].[Region Code].&[GLO], [Customer].[Region Code].&[GLA], [Customer].[Region Code].&[GJT], [Customer].[Region Code].&[GELD], [Customer].[Region Code].&
[GAB], [Customer].[Region Code].&[GA], [Customer].[Region Code].&[FYN], [Customer].[Region Code].&[FRIE], [Customer].[Region Code].&[FLIN], [Customer].[Region Code].&[FLEV], [Customer].[Region Code].&[FL], [Customer].[Region Code].&[FIFE], [Customer].[Region Code].&[FFL], [Customer].[Region Code].&[FDSC], [Customer].[Region Code].&[EXTR], [Customer].[Region Code].&[ESX], [Customer].[Region Code].&[ESS], [Customer].[Region Code].&[ERY], [Customer].[Region Code].&[EMRM], [Customer].[Region Code].&[EFLN], [Customer].[Region Code].&[EDI], [Customer].[Region Code].&[DUR], [Customer].[Region Code].&[DUB], [Customer].[Region Code].&[DRNT], [Customer].[Region Code].&[DNGL], [Customer].[Region Code].&[DLHI], [Customer].[Region Code].&[DF], [Customer].[Region Code].&[DEV], [Customer].[Region Code].&[DER], [Customer].[Region Code].&[DE], [Customer].[Region Code].&[DC], [Customer].[Region Code].&[DADU], [Customer].[Region Code].&[CUM], [Customer].[Region Code].&[CTLN], [Customer].[Region Code].&[CT], [Customer].[Region
Code].&[CSNG], [Customer].[Region Code].&[CRK], [Customer].[Region Code].&[COL], [Customer].[Region Code].&[COAH], [Customer].[Region Code].&, [Customer].[Region Code].&[CNTR], [Customer].[Region Code].&[CNDM], [Customer].[Region Code].&[CMPN], [Customer].[Region Code].&[CLAC], [Customer].[Region Code].&[CHIS], [Customer].[Region Code].&[CHIH], [Customer].[Region Code].&[CHE], [Customer].[Region Code].&[CERE], [Customer].[Region Code].&[CDF], [Customer].[Region Code].&[CBBO], [Customer].[Region Code].&[CARM], [Customer].[Region Code].&[CANT], [Customer].[Region Code].&[CAMB], [Customer].[Region Code].&[CAIT], [Customer].[Region Code].&[CA], [Customer].[Region Code].&[BVRA], [Customer].[Region Code].&[BUC], [Customer].[Region Code].&[BTWN], [Customer].[Region Code].&[BSQU], [Customer].[Region Code].&[BSNM], [Customer].[Region Code].&[BSKR], [Customer].[Region Code].&[BRTG], [Customer].[Region Code].&[BRNE], [Customer].[Region Code].&[BRMN], [Customer].[Region Code].&[BRLN], [Customer].[Region Code].&[BRGS
], [Customer].[Region Code].&[BRGN], [Customer].[Region Code].&[BRGA], [Customer].[Region Code].&[BRAB], [Customer].[Region Code].&[BNWG], [Customer].[Region Code].&[BIOB], [Customer].[Region Code].&[BIAL], [Customer].[Region Code].&[BG], [Customer].[Region Code].&[BER], [Customer].[Region Code].&[BEIJ], [Customer].[Region Code].&[BED], [Customer].[Region Code].&[BDPS], [Customer].[Region Code].&[BC], [Customer].[Region Code].&[BA], [Customer].[Region Code].&[AZNS], [Customer].[Region Code].&[AZ], [Customer].[Region Code].&[AYRE], [Customer].[Region Code].&[AVRG], [Customer].[Region Code].&[AVN], [Customer].[Region Code].&[AS], [Customer].[Region Code].&[ARMA], [Customer].[Region Code].&[ARHS], [Customer].[Region Code].&[ARGU], [Customer].[Region Code].&[AR], [Customer].[Region Code].&[AQTN], [Customer].[Region Code].&, [Customer].[Region Code].&[AOR], [Customer].[Region Code].&[ANTW], [Customer].[Region Code].&[ANTR], [Customer].[Region Code].&[ANHI], [Customer].[Region Code].&[ANGU], [Customer].[Region
Code].&[ANDL], [Customer].[Region Code].&[AND], [Customer].[Region Code].&[ALV], [Customer].[Region Code].&[ALSC], [Customer].[Region Code].&[AL], [Customer].[Region Code].&[AKSS], [Customer].[Region Code].&[AK], [Customer].[Region Code].&[AGS], [Customer].[Region Code].&[AGNN], [Customer].[Region Code].&[ADNA], [Customer].[Region Code].&[ABRZ], [Customer].[Region Code].&[ABE], [Customer].[Region Code].&[AB], [Customer].[Region Code].&[AAGD], [Customer].[Region Code].&[AAC], [Customer].[Region Code].&[AAB], [Customer].[Region Code].&[AA], [Customer].[Region Code].&[]}))}, {[Customer].[Region Code].&[ZUG], [Customer].[Region Code].&[ZRCH], [Customer].[Region Code].&[ZHJG], [Customer].[Region Code].&[ZDHD], [Customer].[Region Code].&[ZAC], [Customer].[Region Code].&[YUNN], [Customer].[Region Code].&[WYO], [Customer].[Region Code].&[WY], [Customer].[Region Code].&[WV], [Customer].[Region Code].&[WTRF], [Customer].[Region Code].&[WSX], [Customer].[Region Code].&[WRW], [Customer].[Region Code].&[WRSW], [Customer
].[Region Code].&[WOR], [Customer].[Region Code].&[WMD], [Customer].[Region Code].&[WISL], [Customer].[Region Code].&[WIL], [Customer].[Region Code].&[WI], [Customer].[Region Code].&[WFLN], [Customer].[Region Code].&[WBNG], [Customer].[Region Code].&[WA], [Customer].[Region Code].&[VT], [Customer].[Region Code].&[VRLB], [Customer].[Region Code].&[VNTO], [Customer].[Region Code].&[VNNA], [Customer].[Region Code].&[VLNC], [Customer].[Region Code].&[VJLE], [Customer].[Region Code].&[VIC], [Customer].[Region Code].&[VI], [Customer].[Region Code].&[VEST], [Customer].[Region Code].&[VER], [Customer].[Region Code].&[VA], [Customer].[Region Code].&[UTRC], [Customer].[Region Code].&[UT], [Customer].[Region Code].&[USMA], [Customer].[Region Code].&[UPPS], [Customer].[Region Code].&[ULPR], [Customer].[Region Code].&[TYRO], [Customer].[Region Code].&[TYN], [Customer].[Region Code].&[TX], [Customer].[Region Code].&[TSCA], [Customer].[Region Code].&[TORF], [Customer].[Region Code].&[TOKY], [Customer].[Region Code].&[TNDU]
, [Customer].[Region Code].&[TN], [Customer].[Region Code].&[TLAX], [Customer].[Region Code].&[TIPN], [Customer].[Region Code].&[TIAN], [Customer].[Region Code].&[THUR], [Customer].[Region Code].&[TAMS], [Customer].[Region Code].&[TA], [Customer].[Region Code].&[SYO], [Customer].[Region Code].&[SXNY], [Customer].[Region Code].&[SXAN], [Customer].[Region Code].&[SUR], [Customer].[Region Code].&[SUF], [Customer].[Region Code].&[STKH], [Customer].[Region Code].&[STIR], [Customer].[Region Code].&[STA], [Customer].[Region Code].&[SP], [Customer].[Region Code].&[SON], [Customer].[Region Code].&[SOM], [Customer].[Region Code].&[SNDJ], [Customer].[Region Code].&[SLTH], [Customer].[Region Code].&[SLP], [Customer].[Region Code].&[SLG], [Customer].[Region Code].&[SK], [Customer].[Region Code].&[SICH], [Customer].[Region Code].&[SHR], [Customer].[Region Code].&[SHNG], [Customer].[Region Code].&[SHND], [Customer].[Region Code].&[SEOU], [Customer].[Region Code].&[SELA], [Customer].[Region Code].&[SD], [Customer].[Region C
ode].&[SCRZ], [Customer].[Region Code].&[SCLA], [Customer].[Region Code].&[SCHH], [Customer].[Region Code].&[SCBO], [Customer].[Region Code].&[SC], [Customer].[Region Code].&[SARA], [Customer].[Region Code].&[SAAR], [Customer].[Region Code].&[RSCM], [Customer].[Region Code].&[RNAL], [Customer].[Region Code].&[RI], [Customer].[Region Code].&[RHPF], [Customer].[Region Code].&[RGLN], [Customer].[Region Code].&[RENF], [Customer].[Region Code].&[QRO], [Customer].[Region Code].&[QR], [Customer].[Region Code].&[QLD], [Customer].[Region Code].&[QC], [Customer].[Region Code].&[PULA], [Customer].[Region Code].&[PUE], [Customer].[Region Code].&[PTCH], [Customer].[Region Code].&[PRTO], [Customer].[Region Code].&[PRHV], [Customer].[Region Code].&[PR], [Customer].[Region Code].&[POW], [Customer].[Region Code].&[PNDC], [Customer].[Region Code].&[PLPN], [Customer].[Region Code].&[PIEM], [Customer].[Region Code].&[PGLA], [Customer].[Region Code].&[PEMB], [Customer].[Region Code].&[PE], [Customer].[Region Code].&[PDLL], [Cust
omer].[Region Code].&[PCRD], [Customer].[Region Code].&[PACD], [Customer].[Region Code].&[PA], [Customer].[Region Code].&[OXO], [Customer].[Region Code].&[OVJS], [Customer].[Region Code].&[OTH], [Customer].[Region Code].&[OSLO], [Customer].[Region Code].&[ON], [Customer].[Region Code].&[OK], [Customer].[Region Code].&[OH], [Customer].[Region Code].&[OBER], [Customer].[Region Code].&[OAX], [Customer].[Region Code].&[NYO], [Customer].[Region Code].&[NY], [Customer].[Region Code].&[NXI], [Customer].[Region Code].&[NVRA], [Customer].[Region Code].&[NV], [Customer].[Region Code].&[NSW], [Customer].[Region Code].&[NS], [Customer].[Region Code].&[NRW], [Customer].[Region Code].&[NRDH], [Customer].[Region Code].&[NRDB], [Customer].[Region Code].&[NPDC], [Customer].[Region Code].&[NOT], [Customer].[Region Code].&[NOR], [Customer].[Region Code].&[NMR], [Customer].[Region Code].&[NMP], [Customer].[Region Code].&[NM], [Customer].[Region Code].&[NL], [Customer].[Region Code].&[NJ], [Customer].[Region Code].&[NH], [Custom
er].[Region Code].&[NGR], [Customer].[Region Code].&[NF], [Customer].[Region Code].&[NEL], [Customer].[Region Code].&[NEID], [Customer].[Region Code].&[NE], [Customer].[Region Code].&[ND], [Customer].[Region Code].&[NC], [Customer].[Region Code].&[NBL], [Customer].[Region Code].&[NB], [Customer].[Region Code].&[MWP], [Customer].[Region Code].&[MTH], [Customer].[Region Code].&[MT], [Customer].[Region Code].&[MS], [Customer].[Region Code].&[MRCA], [Customer].[Region Code].&[MPY], [Customer].[Region Code].&[MOR], [Customer].[Region Code].&, [Customer].[Region Code].&[MNGN], [Customer].[Region Code].&[MN], [Customer].[Region Code].&[MLO], [Customer].[Region Code].&[MI], [Customer].[Region Code].&[MHRS], [Customer].[Region Code].&[MEX], [Customer].[Region Code].&[METR], [Customer].[Region Code].&[MER], [Customer].[Region Code].&[ME], [Customer].[Region Code].&[MDX], [Customer].[Region Code].&[MDRD], [Customer].[Region Code].&[MD], [Customer].[Region Code].&[MB], [Customer].[Region Code].&[MAYO], [Customer].[R
egion Code].&[MALM], [Customer].[Region Code].&[MA], [Customer].[Region Code].&[LWSX], [Customer].[Region Code].&[LTH], [Customer].[Region Code].&[LSBO], [Customer].[Region Code].&[LPZ], [Customer].[Region Code].&[LOND], [Customer].[Region Code].&[LODZ], [Customer].[Region Code].&[LMSN], [Customer].[Region Code].&[LMCK], [Customer].[Region Code].&[LMBR], [Customer].[Region Code].&[LMBD], [Customer].[Region Code].&[LINC], [Customer].[Region Code].&[LIMB], [Customer].[Region Code].&[LIMA], [Customer].[Region Code].&[LIGE], [Customer].[Region Code].&[LGRA], [Customer].[Region Code].&[LEI], [Customer].[Region Code].&[LAZO], [Customer].[Region Code].&[LAR], [Customer].[Region Code].&[LAN], [Customer].[Region Code].&[LA], [Customer].[Region Code].&[KYON], [Customer].[Region Code].&[KY], [Customer].[Region Code].&[KS], [Customer].[Region Code].&[KRLA], [Customer].[Region Code].&[KLK], [Customer].[Region Code].&[KLD], [Customer].[Region Code].&[KEN], [Customer].[Region Code].&[KELA], [Customer].[Region Code].&[JONK]
, [Customer].[Region Code].&[JOHO], [Customer].[Region Code].&[JNGS], [Customer].[Region Code].&[JHCS], [Customer].[Region Code].&[JAL], [Customer].[Region Code].&[IZMR], [Customer].[Region Code].&[ISTN], [Customer].[Region Code].&[ISLE], [Customer].[Region Code].&[IN], [Customer].[Region Code].&[IL], [Customer].[Region Code].&[IDF], [Customer].[Region Code].&[ID], [Customer].[Region Code].&[IA], [Customer].[Region Code].&[HUNN], [Customer].[Region Code].&[HSSN], [Customer].[Region Code].&[HNUT], [Customer].[Region Code].&[HNN], [Customer].[Region Code].&[HN], [Customer].[Region Code].&[HMBG], [Customer].[Region Code].&[HI], [Customer].[Region Code].&[HGO], [Customer].[Region Code].&[HER], [Customer].[Region Code].&[HDLN], [Customer].[Region Code].&[HBEI], [Customer].[Region Code].&[HB], [Customer].[Region Code].&[HAW], [Customer].[Region Code].&[HAM], [Customer].[Region Code].&[GU], [Customer].[Region Code].&[GTO], [Customer].[Region Code].&[GRON], [Customer].[Region Code].&[GRLO], [Customer].[Region Code].
&[GRCC], [Customer].[Region Code].&[GNGD], [Customer].[Region Code].&[GM], [Customer].[Region Code].&[GLO], [Customer].[Region Code].&[GLA], [Customer].[Region Code].&[GJT], [Customer].[Region Code].&[GELD], [Customer].[Region Code].&[GAB], [Customer].[Region Code].&[GA], [Customer].[Region Code].&[FYN], [Customer].[Region Code].&[FRIE], [Customer].[Region Code].&[FLIN], [Customer].[Region Code].&[FLEV], [Customer].[Region Code].&[FL], [Customer].[Region Code].&[FIFE], [Customer].[Region Code].&[FFL], [Customer].[Region Code].&[FDSC], [Customer].[Region Code].&[EXTR], [Customer].[Region Code].&[ESX], [Customer].[Region Code].&[ESS], [Customer].[Region Code].&[ERY], [Customer].[Region Code].&[EMRM], [Customer].[Region Code].&[EFLN], [Customer].[Region Code].&[EDI], [Customer].[Region Code].&[DUR], [Customer].[Region Code].&[DUB], [Customer].[Region Code].&[DRNT], [Customer].[Region Code].&[DNGL], [Customer].[Region Code].&[DLHI], [Customer].[Region Code].&[DF], [Customer].[Region Code].&[DEV], [Customer].[Reg
ion Code].&[DER], [Customer].[Region Code].&[DE], [Customer].[Region Code].&[DC], [Customer].[Region Code].&[DADU], [Customer].[Region Code].&[CUM], [Customer].[Region Code].&[CTLN], [Customer].[Region Code].&[CT], [Customer].[Region Code].&[CSNG], [Customer].[Region Code].&[CRK], [Customer].[Region Code].&[COL], [Customer].[Region Code].&[COAH], [Customer].[Region Code].&, [Customer].[Region Code].&[CNTR], [Customer].[Region Code].&[CNDM], [Customer].[Region Code].&[CMPN], [Customer].[Region Code].&[CLAC], [Customer].[Region Code].&[CHIS], [Customer].[Region Code].&[CHIH], [Customer].[Region Code].&[CHE], [Customer].[Region Code].&[CERE], [Customer].[Region Code].&[CDF], [Customer].[Region Code].&[CBBO], [Customer].[Region Code].&[CARM], [Customer].[Region Code].&[CANT], [Customer].[Region Code].&[CAMB], [Customer].[Region Code].&[CAIT], [Customer].[Region Code].&[CA], [Customer].[Region Code].&[BVRA], [Customer].[Region Code].&[BUC], [Customer].[Region Code].&[BTWN], [Customer].[Region Code].&[BSQU], [
Customer].[Region Code].&[BSNM], [Customer].[Region Code].&[BSKR], [Customer].[Region Code].&[BRTG], [Customer].[Region Code].&[BRNE], [Customer].[Region Code].&[BRMN], [Customer].[Region Code].&[BRLN], [Customer].[Region Code].&[BRGS], [Customer].[Region Code].&[BRGN], [Customer].[Region Code].&[BRGA], [Customer].[Region Code].&[BRAB], [Customer].[Region Code].&[BNWG], [Customer].[Region Code].&[BIOB], [Customer].[Region Code].&[BIAL], [Customer].[Region Code].&[BG], [Customer].[Region Code].&[BER], [Customer].[Region Code].&[BEIJ], [Customer].[Region Code].&[BED], [Customer].[Region Code].&[BDPS], [Customer].[Region Code].&[BC], [Customer].[Region Code].&[BA], [Customer].[Region Code].&[AZNS], [Customer].[Region Code].&[AZ], [Customer].[Region Code].&[AYRE], [Customer].[Region Code].&[AVRG], [Customer].[Region Code].&[AVN], [Customer].[Region Code].&[AS], [Customer].[Region Code].&[ARMA], [Customer].[Region Code].&[ARHS], [Customer].[Region Code].&[ARGU], [Customer].[Region Code].&[AR], [Customer].[Region
Code].&[AQTN], [Customer].[Region Code].&, [Customer].[Region Code].&[AOR], [Customer].[Region Code].&[ANTW], [Customer].[Region Code].&[ANTR], [Customer].[Region Code].&[ANHI], [Customer].[Region Code].&[ANGU], [Customer].[Region Code].&[ANDL], [Customer].[Region Code].&[AND], [Customer].[Region Code].&[ALV], [Customer].[Region Code].&[ALSC], [Customer].[Region Code].&[AL], [Customer].[Region Code].&[AKSS], [Customer].[Region Code].&[AK], [Customer].[Region Code].&[AGS], [Customer].[Region Code].&[AGNN], [Customer].[Region Code].&[ADNA], [Customer].[Region Code].&[ABRZ], [Customer].[Region Code].&[ABE], [Customer].[Region Code].&[AB], [Customer].[Region Code].&[AAGD], [Customer].[Region Code].&[AAC], [Customer].[Region Code].&[AAB], [Customer].[Region Code].&[AA], [Customer].[Region Code].&[]}))), {[Measures].[Sales, (USD)], [Measures].[Sales, Volume (lbs)]}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM [Apollo11Dev] WHERE ([Products].[P-Product Line].&[1,4-Butanediol], [Customer].[City].[Al
l], [Date].[Quarter].[All], [Date].[Year].[All])

I then went to run this query against the same cube, but did it as a MDX query in SQL Management Studio. My CPU instantly goes to 100% (nothing unusual), but this query seems to be taking a very long time. I then went to cancel the query in Management Studio, but that didn't seem to work. I then went into Activity Viewer, and tried to kill connections and sessions. I was able to kill the connection, but the CPU is still pegged at 100%. There is a session that I cannot kill, which I assume is the session for the above query?

It looks as if a restart is the only solution.

Any thoughts?|||

Hello,

now I'm using ActivityViewer for some time and I for most situations it works fine. But I also had couple of queries, which I simply couldn't kill. I had to wait until it was finished.

But you could also experiment with CoordinatorCancelCount, which says how often the engine would come to check if Cancel command wasn't issued. Read more about it at: http://msdn2.microsoft.com/en-us/library/ms174921.aspx

Radim

|||Unfortunately, that property (CoordinatorCancelCount) doesn't seem to be available as I don't see it.