SQL 2000 Clustering

  • I have a 2 system cluster (Active/Passive) running on Windows 2000 Service Pack 4 and 
    SQL 2000 Service Pack 3a. The systems are fully patched to the latest versions. The cluster 
    is running fine, but when several developers connect to the Virtual SQL using a local 
    copy (developers edition) of Enterprise Manager the CPU hits 100% utilisation. This is 
    spread between the cluster services and lsass. If you shutdown all enterprise manager 
    connections it returns to normal. This does not always happen, but is intermittent and 
    does not always occur when the same number of enterprise manager connections are made.
     
    The developers log into one domain and the development cluster is on another domain 
    (both are w2003), but they are not in the same forest (non-transitive trust is set up)
    The cluster is running on Windows 2000
    Any help is appreciated
  • Do you have security patch ms04-011?

    Do you see any related warning/error messages in system log ?

    How long was the CUP in high usage after developers connecting to virtual SQL Server with EM?

     

     

  • Sorry for the late response

    Yes ms04-011 is installed

    There are no errors in the event log

    The CPU is high until you start to disconnect the remote enterprise manager connections afterwhich it returns to normal. You could then connect the same number of EM connections and it works fine.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply