Jul 23, 2005
To All,I have a SQL2KSP3a database(<1GB) running on a 4x3GB physical CPU with4GB of ram. It is Windows Server 2003 with hyper-threading turn on.There are ~420 .Net users/cxns (fat client, no web/app servers) withconnection pooling and ~1 trx/sec. The database growth is neglegeableand actually is not even relevent which I will explain in a minute.99% of the trxs are from one SP that does a select. The resultsets arerelatively small as well 1~100 rows. Yes I have tuned it with indextuning wizard as well, changed the SQL memory configurations, etc....My problem is this...The first day after a reboot, the server runs 6%CPU during peak hours.During the non-peak hours until the next day something apparentlyhappens. The next day (2nd day after a reboot), it jumps to 40%CPUduring peak hours. The server will continue to run at 40%CPU duringpeak hours until the next reboot. This phenomenon has been occurringfor 6 months or more and the traffic on the server is the same for day1 as it is for day 2,3,4,... This database was on another server with100+ dbs and exibited the same behavior, thus bringing that server toits knees, and thus we had to move it to the server in question with noother dbs.I have googled my eyes out, Microsoft site, white papers, perfmon,SQLDiag, PSSDiag, execution plans, index tuning wizard, and the listgoes on! I currently have a case open with Microsoft that has beenopen for months now. I have been passed around to the 3rd "MS TechSpecialist". I have ran PSSDiag a total of 6 times for them for hourson end. I have changed MAXDOP. I could give more information, but Iwould be here for days. I am running out of patience/ideas andMicrosoft is apparently blowing smoke.Any ideas are greatly appreciated!Thanks in advance!JL
View 10 Replies
View Related
May 1, 2008
Hello, I'm installing MOSS 2007 as stand alone which includes SQL Server 2005 Express edition. My install is failing during the DB install. The server is Windows Server 2003, Enterprise Edition SP 2.
The error I'm receiving states "Setup has encountered an unexpected error while updating security settings on HTTP Services".
Here are snippets including the "return value 3" found in the log "SQLSetup0001_COHNTFS15_SQL.log".
Snippet 1:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008
MSI (s) (D8:EC) [08:36:14:535]: Executing op: ActionStart(Name=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting SQL Server Authentication Mode,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (D8:EC) [08:36:14:535]: Executing op: CustomActionSchedule(Action=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_PropSetLoginModeNT,CustomActionData=010Setting SQL Server Authentication Mode50000MSSQL.1)
MSI (s) (D8:40) [08:36:14:535]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI538.tmp, Entrypoint: Do_PropSetLoginModeNT
<Func Name='LaunchFunction'>
Function=Do_PropSetLoginModeNT
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_PropSetLoginModeNT
PerfTime Start: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008
<Func Name='Do_PropSetLoginModeNT'>
Switching server to NT integrated security
<EndFunc Name='Do_PropSetLoginModeNT' Return='0' GetLastError='0'>
PerfTime Stop: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008
MSI (s) (D8:EC) [08:36:14:566]: Executing op: ActionStart(Name=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Updating security settings on HTTP services,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (D8:EC) [08:36:14:566]: Executing op: CustomActionSchedule(Action=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_HttpServiceSecurity,CustomActionData=100Updating security settings on HTTP services100000)
MSI (s) (D84) [08:36:14:566]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI539.tmp, Entrypoint: Do_HttpServiceSecurity
<Func Name='LaunchFunction'>
Function=Do_HttpServiceSecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_HttpServiceSecurity
PerfTime Start: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008
<Func Name='Do_HttpServiceSecurity'>
Error updating HTTPFilter service security (5)
<EndFunc Name='Do_HttpServiceSecurity' Return='1603' GetLastError='0'>
PerfTime Stop: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008
Gathering darwin properties for failure handling.
Error Code: 1603
MSI (s) (D8!20) [08:36:14:785]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
<Failure Type='Fatal' Error='1603'>
<EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'>
MSI (s) (D8:EC) [08:36:14:800]: User policy value 'DisableRollback' is 0
MSI (s) (D8:EC) [08:36:14:800]: Machine policy value 'DisableRollback' is 0
Action ended 8:36:14: InstallFinalize. Return value 3.
Snippet 2:
<Func Name='LaunchFunction'>
Function=Set_CommitFlag
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='F' GetLastError='0'>
Doing Action: Set_CommitFlag
PerfTime Start: Set_CommitFlag : Thu May 01 08:36:22 2008
<Func Name='Set_CommitFlag'>
Set_CommitFlag called successfully.Rollbacked
<EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'>
PerfTime Stop: Set_CommitFlag : Thu May 01 08:36:22 2008
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (D8:EC) [08:36:22:988]: Executing op: ActionStart(Name=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing temporary files,)
MSI (s) (D8:EC) [08:36:22:988]: Executing op: CustomActionRollback(Action=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=RollbackSupportFiles,)
MSI (s) (D8:7C) [08:36:22:988]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI54B.tmp, Entrypoint: RollbackSupportFiles
MSI (s) (D8:EC) [08:36:23:004]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (D8:EC) [08:36:23:004]: Error in rollback skipped. Return: 5
MSI (s) (D8:EC) [08:36:23:004]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.AdomdClient,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:004]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlTDiagM,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:035]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:035]: Entering MsiProvideAssembly. AssemblyName: MSClusterLib,Version="1.0.0.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="1.0.0.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:035]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.MgdSqlDumper,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Rmo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:066]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:066]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.DeploymentEngine,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:066]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.DataWarehouse.Interfaces,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:097]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:097]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.RegSvrEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:097]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.BatchParser,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ServiceBrokerEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:129]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:129]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.WmiEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:129]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:144]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:144]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ConnectionInfo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:144]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:160]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:160]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:160]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SString,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:222]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:222]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Smo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:222]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:238]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:238]: No System Restore sequence number for this installation.
MSI (s) (D8:EC) [08:36:23:238]: Unlocking Server
MSI (s) (D8:EC) [08:36:23:238]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 8:36:23: INSTALL. Return value 3.
last few lines of log:
Property(S): RSVirtualDirectoryManager = Reports$OFFICESERVERS
Property(S): SOURCEDIR = d:a1847ef4f3beaf9c2353Setup
Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Property(S): InstallNgenTicks = 110000
Property(S): SQLBROWSERACCOUNT = NT AUTHORITYNETWORK SERVICE
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {B266876E-56D9-493C-9322-0C01155F1C52}
Property(S): ProductToBeRegistered = 1
MSI (s) (D8:EC) [08:36:23:441]: Note: 1: 1708
MSI (s) (D8:EC) [08:36:23:441]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (D8:EC) [08:36:23:457]: Cleaning up uninstalled install packages, if any exist
MSI (s) (D8:EC) [08:36:23:457]: MainEngineThread is returning 1603
MSI (s) (D84) [08:36:23:566]: Destroying RemoteAPI object.
MSI (s) (D8:E0) [08:36:23:566]: Custom Action Manager thread ending.
=== Logging stopped: 5/1/2008 8:36:23 ===
MSI (c) (104) [08:36:23:597]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (104) [08:36:23:597]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/1/2008 8:36:23 ===
I'm suspecting it's a permission error, but I can't verify this. Any thoughts? Thanks in advance.
View 5 Replies
View Related