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…


5 Questions for Capability and Capacity of High-Performing Teams

Note: This article is updated at 5 Questions for Capability and Capacity of High-Performing Teams. These are five questions I find help understand where a team is at in terms of their ability to achieve their goals effectively: We have capability do we have capacity? We have capacity do we have capability? We have capacity…


Kerberos authPersistNonNTLM authentication, request based vs. session based authentication

This article has been moved to its new home here: https://benperk.github.io/msdn/2011/2011-10-kerberos-authpersistnonntlm-authentication-request-based-vs-session-based-authentication.html Kerberos is a request based authentication protocol.  That means with each request, there is a resulting authentication step.  See the following figure 1 where you notice a Ticket request for each GET Http Command. Figure 1, Network Monitor log for request based authentication This article…


Secure channel compatibility support with SSL and TLS

This article has been moved to its new home here: https://benperk.github.io/msdn/2011/2011-10-secure-channel-compatibility-support-with-ssl-and-tls.html I wrote 2 previous blogs about NTLM and Negotiate/Kerberos which discussed briefly about how those authentication packages work within the context of Integrated Windows Authentication. Another authentication package supported in Windows is called Secure Channel, also known as Schannel.  This blog will not discuss…


NHibernate and Entity Framework essentials using a Model First approach

This article has been moved to its new home here: https://benperk.github.io/msdn/2011/2011-10-nhibernate-and-entity-framework-essentials-using-a-model-first-approach.html Object Relational Mapping technologies have been around for many years.  Hibernate was one of the first, if not the first, ORM library which targeted the Java platform.  Today, there are also NHibernate, which is a port of Hibernate to C# and the ADO.NET Entity…


How to move a Published Table to a new File Group

How to move a Published Table to a new File Group Chris Skorlinski Microsoft SQL Server Escalation Services I recently needed to move a Transactional Replicated table to a new File Group.  There are a couple of documented Schema changes that can break Replication. http://msdn.microsoft.com/en-us/library/ms151870(SQL.90).aspx However, I found most problems are solved if I first…


Update Statistics fails with Error Number:–1073548784 "Could not allocate space for object ‘dbo.SORT”

Update Statistics fails with Error Number: –1073548784 “Could not allocate space for object ‘dbo.SORT” Chris Skorlinski Microsoft SQL Server Escalation Services · ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error Number: -1073548784 Executing the query “UPDATE STATISTICS [dbo].[***********] WITH FULLSCAN ” failed with the following error: “Could not allocate space for object ‘dbo.SORT temporary run storage: 142101814116352’ in database ‘tempdb’ because…