0

How I can catch MDX running queries without profiler? I looks for something like DMV sys.dm_exec_requests, but for SSAS.

Testtest11
  • 367
  • 1
  • 11
  • 26
  • you can't without profiler (AFAIK). Also, why can't you use profiler? – Mitch Wheat Sep 12 '16 at 07:13
  • I cannot use profiler on production database. – Testtest11 Sep 12 '16 at 07:24
  • Can you use Flight Recorder? https://www.google.com/search?sourceid=navclient&aq=&oq=ssas+flight+recorder&ie=UTF-8&rlz=1T4GGNI_enUS551US551&q=ssas+flight+recorder&gs_l=hp...0l2j0i22i30l3.0.0.1.2546692...........0.JZC176LunLQ – Tab Alleman Sep 12 '16 at 17:49

1 Answers1

0

If you are running SQLServer 2012+ maybe you can use Extended Events.

There are indeed some DMV's for running sessions, connections and commands.

mxix
  • 3,539
  • 1
  • 16
  • 23