The Unified Management Console (UMC) pages respond slowly

Products

• Data Center Security Monitoring Edition
• Data Center Security Server
• Data Center Security Server Advanced

Issue/Introduction

When working in the UMC interface pages are loaded very slow.

Environment

DCS 6.7 MP3 and higher versions

Cause

The Data Center Security (DCS) environment is setup to connect to the Microsoft SQL database using a method other than what the DCS Server.xml is configured for.

For example, DCS Server.xml is setup to connect to a Named Instance which will use dynamic port but the SQL Browser service is turned off and/or the instance is configured for static port.

Resolution

To fix this the DCS Server.xml needs to match the SQL Configuration:

If the server.xml is setup for Instance Name and not specifying a port:

• Turn the SQL Browser service on
• Configure the SQL Instance for Dynamic Ports

If the SQL Server needs to remain setup for Static Port, change the server.xml to match that configuration using the examples below.

• In the Server.xml, set the instance to use a static port and specify that port in the Database URL in the server.xml and remove the instance name.
  • The server.xml is located in <DCS Installation Directory>\tomcat\conf
  • There are three lines to change and should look like this:

    Change the following line:
    jdbc:jtds:sqlserver://sqlserver/SCSPDB;instance=SCSP
    Change to:
    jdbc:jtds:sqlserver://sqlserver:1433/SCSPDB

    Change the following line:
    jdbc:jtds:sqlserver://sqlserver/SCSPDB;instance=SCSP
    Change to:
    jdbc:jtds:sqlserver://sqlserver:1433/SCSPDB

    Change the following line:
    jdbc:jtds:sqlserver://sqlserver/dcsc_umc;instance=SCSP
    Change to:
    jdbc:jtds:sqlserver://sqlserver:1433/dcsc_umc