Home

	Expand Search

Enterprise SQL Server Manager Installation and Planning Guide

Chapter 2: Planning an Enterprise SQL Server Manager Deployment

General Considerations for Planning Use of Enterprise SQL Server Manager

General Considerations for Planning Use of Enterprise SQL Server Manager

Managing SQL Server on Unsupported Platforms

Although Enterprise SQL Server Manager allows you to manage SQL Server running on host machines that Tivoli and Enterprise SQL Server Manager do not support, the following restrictions apply:

• You cannot use Enterprise SQL Server Manager to start SQL Server on an unsupported management host. This includes starting SQL Server using:
  • Start SQL Server dialog box
  • sstartserver command
  • Restart Server After Shutdown check box on the Stop SQL Server dialog box
  • -restart option of the sstopserver command
• You cannot delete operating system files designated as the device's physical device name when you delete database devices for a SQL Server running on an unsupported host.
• You cannot use the sinstallaudit command to install the Audit System on SQL Server running on an unsupported host.
• You cannot use Event Monitoring Services to monitor error log entries.

You must manage SQL Server from a supported platform.

Performance

There are several factors that affect the performance of Enterprise SQL Server Manager:

• Number of database administrator operations performed
• Number of objects having an operation being performed on them
• RAM and processing speed of the management host
• Type and speed of the distributed network topology
• Type and speed of the NFS file systems
• Overall performance of the managed SQL Server installations

If you are managing SQL Server installations that are on platforms not supported by Enterprise SQL Server Manager, Sybase recommends that you manage one SQL Server per management host. Managing more than one SQL Server per management host can result in reduced performance.

Network I/O Issues

Depending on your network performance, you may not want to install the TME or Enterprise SQL Server Manager across the network. If not, create a TMR locally and perform the installation of Enterprise SQL Server Manager locally.

In addition to the built-in limitations on TMR size and the enterprise needs that determine policy regions, consider network performance when you plan your TMRs.