Performance hit


i getting started developing reports within reporting services 2005 using vs 2005.  while developing reports, users access database through access, complains of database 'taking long time.'  wondering if there way prevent peformance hit.

 

thanks in advance,

 

mike


mike

hi mike,

the first important thing identifying performance bottlenecks. more details, can refer to:

http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx

1)    timedataretrieval

2)    timeprocessing

3)    timerendering

 

after that, base on bottleneck, try improve performance:

http://blogs.msdn.com/b/deanka/archive/2009/01/13/pet-peeve-slow-reports.aspx

http://sqlcat.com/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx

 

hope helps,

raymond


raymond li - msft


SQL Server  >  SQL Server Reporting Services, Power View



Comments

Popular posts from this blog

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

SQL Server 2008 - High Memory Usage

How to get emails/alerts on all actions on NSG for entire subscription