How to configure individual MSDTC resource with SQL cluster application in SQL Server 2008 Failover Cluster

  In the Windows 2008 Failover Cluster environment, we recommend the “Incoming Caller Authentication Required” security setting for the MSDTC service. I’ll describe how to create the private MSDTC cluster resource for the SQL instance. Environment: Windows 2008 SP2 Failover Cluster SQL Server 2008 Step 1: Install the SQL Server cluster Since this step is…

6

Digging out information from FREB efficiently with PowerShell

  IIS 7.0 provides the FREB method to get verbose requests handling information for all contents file and status code. If we have identified the exact content type and status code for investigation, checking FREB information will not be a challenge.   However, if the status code is general or the content type is not…

1

BizTalk SQL job “MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb” always be shown as suspended in SQL Activity Monitor

  Symptom: According to BizTalk best practice, we should ensure BizTalk related SQL jobs were enabled and running well in SQL agent. These jobs would help maintaining BizTalk Databases under healthy status. However, if go to SQL Activity Monitor, the session status for job “MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb” would always be shown as suspended   Explanation: This symptom…

0

ASP.NET application high CPU utilization caused by “System.NotSupportedException”

  Background: ========== Customer experienced the high CPU utilization with their ASP.NET application and the CPU will fluctuate.   Analysis: ========== We found a lot of exceptions generated and this could severely impact the application performance. We got the crash dump which signified the  “GetManifestResourceNamesForAssembly” throws “System.NotSupportedException”.   The following is the call stack: 0:024>…

0

How to Tune the ASPProcessorThreadMax and EmulateMTSBehavior

  Background Sometimes we may find the ASP requests are very slow because of too many requests queued. Then we can modify the Metabase property of ASPProcessorThreadMax to improve the performance. For more information about how to tune this property, please refer to the following articles http://support.microsoft.com/kb/238583 http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/d4ed262f-11d0-4a87-b15d-57a8c800539e.mspx Analysis Based on the ASPProcessorThreadMax definition, it…

0

Timestamp Difference for FTP Directory Browsing

  If you are familiar with FTP services shipped with Windows Server, you will know there are two directory listing styles available, (Picture link: http://farm3.static.flickr.com/2571/4003532769_98995b000d_o.png) Then what is the difference between UNIX and MS-DOS? I cannot list them all in this post but I will discuss about one significant difference that can lead to problems,…

0