DBI 330 www prologika com atlantabi sqlpass org

DBI 330

www. prologika. com atlantabi. sqlpass. org

Gather workload usage Estimate future loads Derive performance goal • Use the SSRS Execution Log, capture SSAS trace • Look for peak times • How many more users? • Double estimate just in case • Reports/sec or queries/sec • Number of concurrent users • Concurrent users != Deployed users

Users Time 2 concurrent users

Case Study

About reports & queries

demo

Reporting Services

Reporting Services Max. Active. Req. For. One. User setting in rsreportserver. config to a large value, e. g. 999999

Reporting Services

Creating SSRS load test demo

demo

Throughput Reports/sec 80% Users

CPU NETWORK BUS RAM HDD

Run and analyze SSRS load tests demo

demo

http: //asperfwb. codeplex. com/

Load test Analysis Services demo

http: //tinyurl. com/rsperf http: //preview. tinyurl. com/xperfssas

Continued

Identifying performance bottlenecks demo

demo

http: //msdn. microsoft. com/en-us/library/aa 964139(SQL. 90). aspx http: //tinyurl. com/rsperf http: //sqlsrvanalysissrvcs. codeplex. com http: //asperfwb. codeplex. com http: //tinyurl. com/ssas 2008 perfguide http: //tinyurl. com/rs 2005 to 2008 http: //www. prologika. com

Fresenius Medical Care Premier Bankcard Bangkok Bank Public Esurance

http: //www. microsoft. com/visualstudio/en-us/lightswitch http: //www. microsoft. com/expression/ http: //blogs. msdn. com/b/somasegar/ http: //blogs. msdn. com/b/bharry/ http: //www. microsoft. com/sqlserver/en/us/default. aspx http: //www. facebook. com/visualstudio

Connect. Share. Discuss. http: //northamerica. msteched. com Sessions On-Demand & Community Microsoft Certification & Training Resources www. microsoft. com/teched www. microsoft. com/learning Resources for IT Professionals Resources for Developers http: //microsoft. com/technet http: //microsoft. com/msdn

Scan the Tag to evaluate this session now on my. Tech • Ed Mobile