Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New to SSAS - MDX - performance issues - please help !!! Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 9:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:54 AM
Points: 1,274, Visits: 2,937

My MDX query takes way too long (10 mins +). I got these statistics from profiler, they look fine but then why is it taking so long? Is there anything like blockin in SSAS like relation engine?

READS, 7
READ_KB, 39
WRITES, 0
WRITE_KB, 0
CPU_TIME_MS, 0
ROWS_SCANNED, 1280
ROWS_RETURNED, 0
Post #1438860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse