In Microsoft Internet Security and Acceleration (ISA) Server 2006, you may receive a "Log Write Time Excessive" alert when a new MSDE database is created.
↑ Back to the top
When ISA Server 2006 creates a new MSDE database file for logging, it sets its initial database size to 75 megabytes (MB) and its growth size to 75 MB. However, ISA Server does not set the size of the MSDE transaction log file. By default, the initial log size is 1 MB and grows by 10 percent. If many records are to be logged, the MDSE transaction log file must expand large enough to hold the records. At an expansion rate of 10 percent, the transaction log file has to expand many times to be large enough. Therefore, it takes a long time for the records to be committed on the first commit after database creation. Usually this occurs when several thousand records are committed.
↑ Back to the top
To resolve this problem, follow these steps:
- Download and then install the hotfix package that is mentioned in the following Microsoft Knowledge Base article:
960927 Description of the ISA Server 2006 hotfix package: December 7, 2008
- Start Notepad, and then copy the following script into a Notepad file.
Const SE_VPS_GUID = "{143F5698-103B-12D4-FF34-1F34767DEabc}"
Const SE_VPS_NAME = "UseExtendedMSDELogFile"
Const SE_VPS_VALUE = true
Sub SetValue()
' Create the root obect.
Dim root ' The FPCLib.FPC root object
Set root = CreateObject("FPC.Root")
'Declare the other objects needed.
Dim array ' An FPCArray object
Dim VendorSets ' An FPCVendorParametersSets collection
Dim VendorSet ' An FPCVendorParametersSet object
' Get references to the array object
' and the network rules collection.
Set array = root.GetContainingArray
Set VendorSets = array.VendorParametersSets
On Error Resume Next
Set VendorSet = VendorSets.Item( SE_VPS_GUID )
If Err.Number <> 0 Then
Err.Clear
' Add the item
Set VendorSet = VendorSets.Add( SE_VPS_GUID )
CheckError
WScript.Echo "New VendorSet added... " & VendorSet.Name
Else
WScript.Echo "Existing VendorSet found... value- " & VendorSet.Value(SE_VPS_NAME)
End If
if VendorSet.Value(SE_VPS_NAME) <> SE_VPS_VALUE Then
Err.Clear
VendorSet.Value(SE_VPS_NAME) = SE_VPS_VALUE
If Err.Number <> 0 Then
CheckError
Else
VendorSets.Save false, true
CheckError
If Err.Number = 0 Then
WScript.Echo "Done with " & SE_VPS_NAME & ", saved!"
End If
End If
Else
WScript.Echo "Done with " & SE_VPS_NAME & ", no change!"
End If
End Sub
Sub CheckError()
If Err.Number <> 0 Then
WScript.Echo "An error occurred: 0x" & Hex(Err.Number) & " " & Err.Description
Err.Clear
End If
End Sub
SetValue
- Save the file as a Microsoft Visual Basic script file by using the .vbs file name extension. For example, save the file as ConfigLogsizeGrowth.vbs in the C:\ConfigLogsizeGrowth folder.
- At a command prompt, move to the location of the .vbs file, and then run the .vbs file. For example, run the following commands:
cd C:\ConfigLogsizeGrowth
cscript ConfigLogsizeGrowth.vbs
Note After you enable this hotfix, the log file size is set to grow by 2 MB.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
↑ Back to the top
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
↑ Back to the top