SQL Server Performance

A problem of install SQL server on win2003 cluster

Discussion in 'SQL Server Clustering' started by muchengxue, Nov 9, 2004.

  1. muchengxue New Member

    I have two HP DL560 server running on windows 2003 cluster. The cluster and the MSDTC service is running well. When I just installed SQL server 2000 enterprise on the windows 2003 server,I met a problem.I want to install the SQL server with virtual server mode.After the installation shield register me to input the virual server name,server's IP address,volume of database saved,possible cluster node and administrator's password,when I click "next" to continue,the installation is canceled automatic.After several minutes,the "sqlsetup" process is killed by system.
    But if the server is running without cluster,the installation program can complete finish.
    What a strange thing it is. It have puzzled me for three days now.
    Please help me, thanks a lot!

    I am glad to meet you
  2. Twan New Member


    SQL creates a log file on your c: drive called something like sqlsetup.log? (others may correct me here) check if there are any errors in here...? also I assume that there are no error message in the event logs?

    Cheers
    Twan
  3. muchengxue New Member

    Thanks for your answer,I will check it.
    And did anyone meet this problem ?


    I am glad to meet you
  4. Twan New Member

    Hi ya,<br /><br />no I've installed 4 w2k3 clusters with no real issues, nothing as sever as this anyway <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />Cheers<br />Twan
  5. bradmcgehee New Member

    I have never seen this issue either. If I were faced with it, I would probably rebuild my servers from scrath, paying particular attention to all the details to ensure I wasn't making any mistakes. Also, be sure all of your hardware is on the Microsoft HCL.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  6. Tolwyn New Member

    Same problem here.

    When we installed the SQL-Instances at the Windows 2003 cluster, sometimes the installation aborted with a "performance-error" message.

    After some trying, all seven instances were finally installed correctly on the cluster.

    But as we installed SP3a after, the same strange behavior occured. The installation of the SP aborted three times. After some trying we got the SPs running.

    We also use HP Proliant DL560 as nodes. Everything is on the MS HCL.
    All in all we have three two-node-cluster (six DL560). All servers are absolut identical. On every cluster the OS is Win2003 with several SQL2000 SP3a instances installed.

    Strange Installation occured on Cluster two and three. Cluster one went fine.

    Now everything is installed on the clusters, cluster2 is still making trouble while cluster1 and cluster 2 are OK.

    When initiating a failover on cluster2 all instance move to the other node except one instance. Alway the last instance to be moved fails on the other node (exactly the SQL Agent ressource fails) and moves back to zhe original node.

    After rebooting both nodes the behaviour is gone and i can move all instances. Some hours later the same happens again: alls groups are movable, except one. It not always the same ressource, its alway the last one.

    Does anybody have an idea?


    Greetings from Germany (sorry for my english)
    Tolwyn

  7. bradmcgehee New Member

    I have not seen this behavior. But if I did, I would be on the phone immediately with Microsoft Support to figure it out. This is definitely not normal.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  8. muchengxue New Member

    Thanks for all answer.
    Yesterday afternoon I reinstalled my two HP DL 560 with OS windows 2000 advanced server.Then I configed two-nodes cluster and the cluster went fine.But when I installed SQL server 2000 enterprise ,the same issue occured.What a strange thing!I just paste the "sqlstp.log".I hope you can read it and give some way to resolve this hard question.
    The log created by the time when I installed SQL on my second node.
    the log is:
    17:48:00 Begin Setup
    17:48:00 8.00.194
    17:48:00 Mode = Normal
    17:48:00 ModeType = NORMAL
    17:48:00 GetDefinitionEx returned: 0, Extended: 0x0
    17:48:00 ValueFTS returned: 1
    17:48:00 ValuePID returned: 1
    17:48:00 ValueLic returned: 1
    17:48:00 System: Windows NT Enterprise Server
    17:48:00 SQL Server ProductType: Enterprise Edition [0x3]
    17:48:00 IsNTCluster returned: 0
    17:48:00 Begin Action: SetupInitialize
    17:48:00 End Action SetupInitialize
    17:48:00 Begin Action: SetupInstall
    17:48:00 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir ...
    17:48:00 CommonFilesDir=C:program FilesCommon Files
    17:48:00 Windows Directory=C:WINDOWS17:48:00 Program Files=C:program Files17:48:00 TEMPDIR=C:WINDOWSTEMP17:48:00 Begin Action: SetupInstall
    17:48:00 digpid size : 256
    17:48:00 digpid size : 164
    17:48:00 Begin Action: CheckFixedRequirements
    17:48:00 Platform ID: 0xf00000
    17:48:00 Version: 5.2.3790
    17:48:00 File Version - C:WINDOWSsystem32shdocvw.dll: 6.0.3790.0
    17:48:00 End Action: CheckFixedRequirements
    17:48:01 Begin Action: ShowDialogs
    17:48:01 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
    17:48:01 Begin Action ShowDialogsHlpr: 0x1
    17:48:01 Begin Action: DialogShowSdWelcome
    17:48:02 End Action DialogShowSdWelcome
    17:48:02 Dialog 0x1 returned: 1
    17:48:02 End Action ShowDialogsHlpr
    17:48:02 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
    17:48:02 Begin Action ShowDialogsHlpr: 0x2
    17:48:02 Begin Action: DialogShowSdMachineName
    17:48:07 ShowDlgMachine returned: 1
    17:48:07 Name = CLUSTER-SERVER1, Type = 0x1
    17:48:07 Begin Action: CheckRequirements
    17:48:07 Processor Architecture: x86 (Pentium)
    17:48:07 ComputerName: CLUSTER-SERVER1
    17:48:07 User Name: Administrator
    17:48:07 IsAllAccessAllowed returned: 1
    17:48:07 OS Language: 0x804
    17:48:07 End Action CheckRequirements
    17:48:07 This combination of Package and Operating System allows a full product install.
    17:48:07 CreateSetupTopology(CLUSTER-SERVER1), Handle : 0x16940f8, returned : 0
    17:48:07 CreateSetupTopology returned : 0, Handle : 0x16940f8
    17:48:07 Topology Type : 1, Return Value : 0
    17:48:07 ST_GetPhysicalNode returned : 0, PNHandle : 0x1694148
    17:48:07 PN_EnumerateEx returned : 0
    17:48:07 PN_GetSQLStates returned : 0, SqlStates : 0x0
    17:48:07 PN_StartScan [0x1694148] returned : 0
    17:48:07 PN_GetNext [0x1694148] returned : 18, Handle: [0x0]
    17:48:07 No more items in enumeration.
    17:48:07 ReleaseSetupTopology
    17:48:07 Named instance limit: 100, quota: 0
    17:48:07 End Action DialogShowSdMachineName
    17:48:07 begin ShowDialogsUpdateMask
    17:48:07 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
    17:48:07 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
    17:48:07 Dialog 0x2 returned: 0
    17:48:07 End Action ShowDialogsHlpr
    17:48:07 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
    17:48:07 Begin Action ShowDialogsHlpr: 0x4
    17:48:07 Begin Action: DialogShowSdInstallMode
    17:48:09 ShowDlgInstallMode returned: 1
    17:48:09 InstallMode : 0x1
    17:48:09 End Action DialogShowSdInstallMode
    17:48:09 begin ShowDialogsUpdateMask
    17:48:09 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
    17:48:09 Updated Dialog Mask: 0x1bf40037, Disable Back = 0x1
    17:48:09 Dialog 0x4 returned: 1
    17:48:09 End Action ShowDialogsHlpr
    17:48:09 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
    17:48:09 Begin Action ShowDialogsHlpr: 0x10
    17:48:09 Begin Action: DialogShowSdRegisterUserEx
    17:48:11 End Action DialogShowSdRegisterUserEx
    17:48:11 Dialog 0x10 returned: 1
    17:48:11 End Action ShowDialogsHlpr
    17:48:11 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
    17:48:11 Begin Action ShowDialogsHlpr: 0x20
    17:48:11 Begin Action: DialogShowSdLicense
    17:48:12 End Action DialogShowSdLicense
    17:48:12 Dialog 0x20 returned: 1
    17:48:12 End Action ShowDialogsHlpr
    17:48:12 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
    17:48:12 Begin Action ShowDialogsHlpr: 0x40000
    17:48:12 Begin Action: DialogShowSdCliSvr
    17:48:12 DisplaySystemPreReq
    17:48:14 ShowDlgClientServerSelect returned: 1
    17:48:14 Type : 0x2
    17:48:14 End Action DialogShowSdCliSvr
    17:48:14 begin ShowDialogsUpdateMask
    17:48:14 nFullMask = 0x1bf40037, nCurrent = 0x40000, nDirection = 1
    17:48:14 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
    17:48:14 Dialog 0x40000 returned: 1
    17:48:14 End Action ShowDialogsHlpr
    17:48:14 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
    17:48:14 Begin Action ShowDialogsHlpr: 0x80000
    17:48:14 Begin Action: DialogShowSdInstanceName
    17:48:14 Begin Action: ShowDlgInstanceName
    17:48:15 End Action: ShowDlgInstanceName
    17:48:15 ShowDlgInstanceName returned : 1
    17:48:15 InstanceName : MSSQLSERVER
    17:48:15 CreateSetupTopology(CLUSTER-SERVER1), Handle : 0x16940f8, returned : 0
    17:48:15 CreateSetupTopology returned : 0, Handle : 0x16940f8
    17:48:15 Topology Type : 1, Return Value : 0
    17:48:15 ST_GetPhysicalNode returned : 0, PNHandle : 0x1694148
    17:48:15 PN_EnumerateEx returned : 0
    17:48:15 PN_GetSQLStates returned : 0, SqlStates : 0x0
    17:48:15 PN_StartScan [0x1694148] returned : 0
    17:48:15 PN_GetNext [0x1694148] returned : 18, Handle: [0x0]
    17:48:15 No more items in enumeration.
    17:48:15 ReleaseSetupTopology
    17:48:15 End Action DialogShowSdInstanceName
    17:48:15 begin ShowDialogsUpdateMask
    17:48:15 nFullMask = 0x1bfc0037, nCurrent = 0x80000, nDirection = 1
    17:48:15 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
    17:48:15 Dialog 0x80000 returned: 1
    17:48:15 End Action ShowDialogsHlpr
    17:48:15 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
    17:48:15 Begin Action ShowDialogsHlpr: 0x100000
    17:48:15 Begin Action: DialogShowSdSetupType
    17:48:15 Begin Action: Setup Type
    17:48:44 Action Exit Handler:
    17:48:46 StatsGenerate returned: 2
    17:48:46 StatsGenerate (0x0,0x1,0xf00000,0x0,2052,303,0x0,0x1,0,0,0
    17:48:46 StatsGenerate -1,Administrator)



    ----------------
    thanks a lot for all of you

    I am glad to meet you
  9. muchengxue New Member

    the newest log file of today is:
    10:47:29 Begin Setup
    10:47:29 8.00.194
    10:47:29 Mode = Normal
    10:47:29 ModeType = NORMAL
    10:47:29 GetDefinitionEx returned: 0, Extended: 0x0
    10:47:29 ValueFTS returned: 1
    10:47:29 ValuePID returned: 1
    10:47:29 ValueLic returned: 1
    10:47:29 System: Windows NT Enterprise Server
    10:47:29 SQL Server ProductType: Enterprise Edition [0x3]
    10:47:29 IsNTCluster returned: 1
    10:47:29 Begin Action: SetupInitialize
    10:47:29 End Action SetupInitialize
    10:47:29 Begin Action: SetupInstall
    10:47:29 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir ...
    10:47:29 CommonFilesDir=C:program FilesCommon Files
    10:47:29 Windows Directory=C:WINNT10:47:29 Program Files=C:program Files10:47:29 TEMPDIR=C:WINNTTEMP10:47:29 Begin Action: SetupInstall
    10:47:29 digpid size : 256
    10:47:29 digpid size : 164
    10:47:29 Begin Action: CheckFixedRequirements
    10:47:29 Platform ID: 0xf00000
    10:47:29 Version: 5.0.2195
    10:47:29 File Version - C:WINNTSystem32shdocvw.dll: 5.0.2920.0
    10:47:29 End Action: CheckFixedRequirements
    10:47:29 Begin Action: ShowDialogs
    10:47:29 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
    10:47:29 Begin Action ShowDialogsHlpr: 0x1
    10:47:29 Begin Action: DialogShowSdWelcome
    10:47:31 End Action DialogShowSdWelcome
    10:47:31 Dialog 0x1 returned: 1
    10:47:31 End Action ShowDialogsHlpr
    10:47:31 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
    10:47:31 Begin Action ShowDialogsHlpr: 0x2
    10:47:31 Begin Action: DialogShowSdMachineName
    10:47:46 ShowDlgMachine returned: 1
    10:47:46 Name = CNLMG-SQL, Type = 0x10000008
    10:47:46 Begin Action: CheckRequirements
    10:47:46 Processor Architecture: x86 (Pentium)
    10:47:46 ComputerName: CLUSTER-SERVER2
    10:47:46 User Name: Administrator
    10:47:46 IsAllAccessAllowed returned: 1
    10:47:46 OS Language: 0x804
    10:47:46 End Action CheckRequirements
    10:47:46 This combination of Package and Operating System allows a full product install.
    10:47:46 End Action DialogShowSdMachineName
    10:47:46 begin ShowDialogsUpdateMask
    10:47:46 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
    10:47:46 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
    10:47:46 Dialog 0x2 returned: 0
    10:47:46 End Action ShowDialogsHlpr
    10:47:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
    10:47:46 Begin Action ShowDialogsHlpr: 0x4
    10:47:46 Begin Action: DialogShowSdInstallMode
    10:47:46 InstallMode : 0x1
    10:47:46 End Action DialogShowSdInstallMode
    10:47:46 begin ShowDialogsUpdateMask
    10:47:46 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
    10:47:46 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    10:47:46 Dialog 0x4 returned: 1
    10:47:46 End Action ShowDialogsHlpr
    10:47:46 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
    10:47:46 Begin Action ShowDialogsHlpr: 0x10
    10:47:46 Begin Action: DialogShowSdRegisterUserEx
    10:48:16 End Action DialogShowSdRegisterUserEx
    10:48:16 begin ShowDialogsUpdateMask
    10:48:16 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
    10:48:16 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    10:48:16 Dialog 0x10 returned: 1
    10:48:16 End Action ShowDialogsHlpr
    10:48:16 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
    10:48:16 Begin Action ShowDialogsHlpr: 0x20
    10:48:16 Begin Action: DialogShowSdLicense
    10:48:20 End Action DialogShowSdLicense
    10:48:20 Dialog 0x20 returned: 1
    10:48:20 End Action ShowDialogsHlpr
    10:48:20 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
    10:48:20 Begin Action ShowDialogsHlpr: 0x4000
    10:48:20 Begin Action: DialogShowSdVirtualServer
    10:48:41 ShowDlgVirtualServer returned: 0
    10:48:41 Ipaddress = 202.197.81.229,255.255.255.240,1ºÅÍø¿¨
    10:48:41 szNewList = 202.197.81.229,255.255.255.240,1ºÅÍø¿¨
    10:48:41 szModifiedList =
    10:48:41 szRemovedList =
    10:48:41 End Action DialogShowSdVirtualServer
    10:48:41 begin ShowDialogsUpdateMask
    10:48:41 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
    10:48:41 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    10:48:41 Dialog 0x4000 returned: 1
    10:48:41 End Action ShowDialogsHlpr
    10:48:41 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
    10:48:41 Begin Action ShowDialogsHlpr: 0x8000
    10:48:41 Begin Action : DialogShowSdDiskGroups
    10:48:46 ShowDlgDiskGroups returned: 1
    10:48:46 Disk Group = group 0
    10:48:46 End Action : DialogShowSdDiskGroups
    10:48:46 begin ShowDialogsUpdateMask
    10:48:46 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
    10:48:46 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    10:48:46 Dialog 0x8000 returned: 1
    10:48:46 End Action ShowDialogsHlpr
    10:48:46 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
    10:48:46 Begin Action ShowDialogsHlpr: 0x10000
    10:48:46 Begin Action: DialogShowSdClusterDef
    10:48:47 ShowDlgClusterDef returned: 1
    10:48:47 PrefOwners = CLUSTER-SERVER2,CLUSTER-SERVER1, NumIp = 2
    10:48:47 Begin Action : ValidateNodeActions
    10:48:47 Begin Action : ValidateNodeActions
    10:48:47 End Action : ValidateNodeActions
    10:48:47 End Action : ValidateNodeActions
    10:48:47 End Action DialogShowSdClusterDef
    10:48:47 begin ShowDialogsUpdateMask
    10:48:47 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
    10:48:47 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    10:48:47 Dialog 0x10000 returned: 1
    10:48:47 End Action ShowDialogsHlpr
    10:48:47 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
    10:48:47 Begin Action ShowDialogsHlpr: 0x20000
    10:48:47 Begin Action : Cluster Security - DlgAcct





    I am glad to meet you
  10. Argyle New Member

Share This Page