Monitor Lazy aggregation processing using SQL Server Profiler 2008

This is a discussion on Monitor Lazy aggregation processing using SQL Server Profiler 2008 within the sqlserver-olap forums in Data Warehousing category; Hi, Anybody knows how to monitor Lazy processing using SQL server profiler? I am using SSAS 2008. I have created cube dimensions and set the ProcessingMode to LazyAggregations. Lazy processing is enabled on the server. When I change the ProcessingMode to Regular and Process a dimension with ProcessUpdate option, Profiler shows Build Indexes etc. When the ProcessingMode is LazyAggregations, I don't see these entries on ProcessUpdate. I am monitoring the profiler to see when AS will build these indexes, but couldn't find it. Is there a way to monitor the same? Thanks, Padmaja...

Go Back   Database Forum > Data Warehousing > sqlserver-olap

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-25-2008, 09:14 AM
Default Monitor Lazy aggregation processing using SQL Server Profiler 2008

Hi,

Anybody knows how to monitor Lazy processing using SQL server profiler? I am
using SSAS 2008. I have created cube dimensions and set the ProcessingMode to
LazyAggregations. Lazy processing is enabled on the server. When I change the
ProcessingMode to Regular and Process a dimension with ProcessUpdate option,
Profiler shows Build Indexes etc. When the ProcessingMode is
LazyAggregations, I don't see these entries on ProcessUpdate. I am monitoring
the profiler to see when AS will build these indexes, but couldn't find it.
Is there a way to monitor the same?

Thanks,
Padmaja
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:43 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.