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

Microsoft Anti-Cross Site Scripting Library V3.0 Beta Performance Testing Results

The Microsoft Anti-Cross Site Scripting Library V3.0 (Anti-XSS V3.0) is an encoding library designed to help developers protect their ASP.NET web-based applications from XSS attacks. It differs from most encoding libraries in that it uses the white-listing technique — sometimes referred to as the principle of inclusions — to provide protection against XSS attacks. This…

2

lsass.exe and w3wp.exe: Analyzing SSL performance in IIS 6.0

In several of the performance tuning projects I have done, the web pages with security settings such as SSL or Windows authentication are generally slow compared to other pages. In this post, I analyze how SSL performance can be monitored in IIS 6.0 As per the architecture of IIS 6.0, security related operations such as…

1

Visual Round Trip Analyzer – Scorecard

I happened to use this new performance tool called Visual Round trip analyzer for one of my recent projects.  Here’s a little description given on the VRTA download page.   The Visual Round Trip Analyzer tool helps web developers and testers visualize the download of their page, identify best practices and changes that improve web…

2

Recession: Effects on Internet and Web performance

“Effects of Recession” is the burning topic of the moment and everyone is concerned about cost-cuts and other measures to overcome the crisis. I attended few talks by business leaders on economic collapse and crisis that’s going on. It is fascinating to see how people fail to recognize simple things at right time, especially the…

1

Application Pool Properties– Worker Process Idle Time Shut down setting

From my past experience I have learned that most of the project teams are not aware of App Pool properties of IIS. They tend to rely on the default values of App Pool. Even though the default values are chosen to give better performance in general, the values might not be suitable for your project….

3

Web server deadlocks – aspnet_isapi.dll

There are various reasons for a deadlock can occur on the web server. In this blog post, I would be pointing out the various ways to resolve aspnet_isapi.dll related deadlocks on web server. If the deadlock has occurred on the web server, you should notice a warning or error on Event Viewer. In one of…

2