search cancel

The Unified Management Console (UMC) pages respond slowly

book

Article ID: 163775

calendar_today

Updated On:

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.

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