SQL Server Blocked Process Report using SQL Profiler

Today, I learnt something new with SQL Server Profiler while doing performance testing of an internal Microsoft application. It is about SQL Server Blocked Process Report. Using SQL Server Blocked Process report, one can find the portion of the code that is spending most time in blocked state. The Errors and Warnings Event has a…

1

Performance Development Lifecycle for IT (PDL-IT)

Performance Development Lifecycle for IT (PDL-IT) is systematic approach developed by Microsoft’s ACE team in order to improve the application performance of Microsoft’s line of business (LOB) and web applications built on top of Microsoft technologies. The process encompasses the addition of a series of performance focused activities and deliverables at each of the phases…

1

Why Performance testing and tuning of PerformancePoint planning server 2007?

PerformancePoint planning server 2007 is a multi-tier architecture consisting of technologies such as Microsoft SQL Server 2005, SQL Analysis services, web services and ASP.NET web applications hosted on IIS and Microsoft Office Excel plug-in. With all the different technologies involved, it is important to establish equilibrium between user load and system resources for the given…


PerformancePoint Server 2007- White papers

Several white papers have been published by the PerformancePoint Product team on the best practices of PerformancePoint Server 2007. We recommend the architects, developers, testers, deployment engineers and Operational engineers to read and follow best practices presented in the concerned white papers. This will be highly beneficial in avoiding bugs at the very early stage…

1