MSMQ Independent Client Installation on a Cluster SQL Server 7.0
- MS DTC and it’s DLL should be removed
- MS Message Queuing Installation
- MS DTC Upgration
Message Queuing Installation and Cluster Setup with SQL Server 7.0 and Message Queuing :
- SQL Server and SQL Server Agent should be stopped
- Run Command : msdtc -remove on Server1
- Run Command : msdtc -remove on Server2
- Remove MS DTC reource in Cluster Resource Group
- Locate and remove : HKEY_LOCAL_MACHINE\Software\Microsoft\MSDTC
- On each node, delete files in \%windir%\System32 folder :
- Adme.dll
- Dtcadmc.dll
- Dtccfg.cpl
- Dtccm.dll
- Dtctrace.dll
- Dtctrace.exe
- Dtcuic.dll
- Dtcuis.dll
- Dtcutil.dll
- Dtcxatm.dll
- Dtcsetup.exe
- Msdtc.dll
- Msdtc.exe
- Msdtcprx.dll
- Msdtctm.dll
- Msdtcw.exe
- Reboot Nodes
MS Message Queuing Installation :
- Move SQL Server group that containts MS DTC and Message Queuing to Servers.
- Move all to Server2
- Message Queuing Routing Server Installation on Server1
- Run Setup.exe which is located in \Msmq\Msmq\Server folder on MS Windows NT Server 4.0 Ent. Edition Component CD
- It will run until 0×424 error for MS DTC is reported.
- Click Ok
- While Installation, Click Customer and clear installation share and then click Route Server. When Primary Site Controller is prompted, type PSC name
- In IP Address list, click IP with group, this is required that Message Queuing that is used to communicate with other Message Queuing.
- In Connected Network drop-down, click connected network and Continue.
- When Error is seen, Click Ok
- Click Yes to continue when it shows MS DTC cannot start.
- At prompt of MSMQ installation, Click Ok
- Start Cluster Administrator, open Properties of MS DTC resource
- On Advanced, click clear Affect group and apply
- It will be seen that MS DTC service will be offline
- Move resource group to Server2 and other resource to Server1
- Message Queuing should be offline
- Run Message Queuing Setup on Server2.
MS DTC Upgration :
- Move resource group back to Server1
- Run Dtcsetup.exe from SQL Server 7.0 CD – \x86\Other on Server1
- Run Dtcsetup.exe on Server2 and click Ok on Server1
- In Cluster Administrator, Right-click MS DTC resource, click Dependencies.
- Add SQL Servers to the list.
- MS DTC and Message Queuing should be Online
- All resource should be on node and Windows NT 4.0 SP4 should be applied
- Server1 should be Restarted now and all resources should be moved
- Apply Windows NT 4.0 SP4 to Server1 and Restart Node
SQL Dedicated Server Configuration is an important setup for SQL databases, these include the following :
- Affinity Mask
- Lightweight Pooling
- Max Async IO
- Max Worker Threads
- Memory
- Priority Boost
- Set Working Set Size
SQL Dedicated Servers can achieve good performance with only a bit of tweaks. This include applications / database configurations. SQL servers always have higher trend to increase performance. SQL Server also has automatic configurations for the server. If SQL is not configured properly, it may cause a lot of problems on the dedicated server. It is very important that we make a note of every installation and configuration.
It also includes the following features :
- Replication
- Text Search
- XML Data Management
- Service Analysis and Alerts
- SQL Server Agent
- SQL Browser
- SQL Debugging
- SQLimail
- Mirroring of Database
SQL Dedicated Servers can be utilized for database management of high-end configuration.
SQL Server Clusters are setup when requirements of applications or Databases are not met. This is a setup to ensure performance is maintained at all times. While setting up a Cluster, you need to make sure you have noticed the following facts :
- Applications usage and their response.
- Uptime is maintained at all times even when a e-commerce applications is taking place.
- Loss in case of application failure.
- Apllication setup need mainenance.
- Maintenance and upgrades take place without any application downtime.
- Additional maintenance and training cost.
- Unification of Applications and resources.
- Increase availability in failures or downtime.
- Enhance Scalibility.
- Share load accross multiple servers.
- Clusters are basic of two type : Asymmetric Clusters and Symmetric Clusters
- Asymmetric Clusters refers to server exists to take over another server in case of any failure. It is efficient for availability and scalability for databases, files and services. In case, one of the servers are down, the other server takes place of the first server node. One of the terms refers to failover cluster.
- Symmetric Clusters, in this every server performance the same task. In this case, every server is the main server for applications. In case, one of them fail, the remaining servers continue to process applications. When it comes to cost, cluster resources are used. However, the only problem with it is in case of failure, additional load on other server could fail them.
- Load Management with Server Clusters
- Avoid Interruption of Services
- Increase in Flexibility.
- Complex Infrastructure in more number of servers are not easy to manage.
- Code Changes to function with all the servers.
- Applicaton limitations are not supported on Server Clusters.
SQL Dedicated Server Clusters Solutions are designed to meet Corporate Requirements and manage heavy databases / applications. BODHost provides fully managed dedicated server clustering solutions. SQL Server are normally setup with Server clusters.
If you need any further information, please email us at sales @ bodhost.com and we will suggest the best cluster setup for your applications.