The Unified Management Console (UMC) pages respond slowly
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.

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

    • DCS 6.9.x (4 Lines that will need changed)

      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

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

    • DCS 6.7 and DCS 6.8 (3 Lines that will need changed)

      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