Excruciating rhymes

This blog post has moved to https://matthewvaneerde.wordpress.com/2011/12/16/excruciating-rhymes/


Performance of index creation

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-of-index-creation/ba-p/367170 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html The creation of database indexes is often a significant part in SAP BW process chains. Even on up-to-date database servers the index creation on a BW cube…


Creating a W3WP Memory dump on Windows Server 2003

This article has been moved to its new home here: https://benperk.github.io/msdn/2011/2011-12-creating-a-w3wp-memory-dump-on-windows-server-2003.html On a web server with multiple application pools, there most likely will be multiple W3WP processes.  Therefore, the first action to take when creating a memory dump of a W3WP worker process is to find which one you need to get the dump of….


Finding the W3WP worker process PID and associated ID

This article has been moved to its new home here: https://benperk.github.io/msdn/2011/2011-12-finding-the-w3wp-worker-process-pid-and-associated-id.html When you have multiple websites running under different application pools on the same server, you may need to trouble shoot a specific worker process. On Windows 2003 and Internet Information Services 6 (IIS6), I use the iisapp.vbs script as shown in following command, as…


Setting up performance counters for ASP.NET

This article has been moved to its new home here: https://benperk.github.io/msdn/2011/2011-11-setting-up-performance-counters-for-asp-net.html Troubleshooting a performance problem can be very complicated.  Unfortunately, in many cases you prepare and begin learning about how to fix a performance problem when it is happening or just after a performance problem.  The fact is, you need to monitor your system and…


Modify the Request Queue Limit, requestQueueLimit or Queue Length in IIS 7

This article has been moved to its new home here:  https://benperk.github.io/msdn/2011/2011-11-modify-the-request-queue-limit-requestqueuelimit-or-queue-length-in-iis.html When optimizing and tuning an ASP.NET application you may want to increase the value of the requestQueueLimit.  The requestQueueLimit is the maximum number of requests that can be queued by an ASP.NET process before errors get returned to the client. Modify Request Queue Limit…