Setting up a SQL Server database and user for TrueSight Server Automation

This topic provides instructions for setting up a SQL Server database and user for a fresh installation of TrueSight Server Automation database.

Warning

These tasks should be performed by a database administrator (DBA). Perform the steps in the exact order in which they are described.

This topic includes the following sections:

Related topics

Walkthrough: Setting up a SQL Server database

Setting-up-an-Oracle-database-for-TrueSight-Server-Automation

Requirements and recommendations

  • Click here for a list of supported SQL Server databases.
    • 2022 (EE, SE)
    • 2022 Cluster (EE, SE)
    • 2019 (EE, SE)
    • 2017 (EE, SE)
    • 2016 (EE, SE)
    • 2014 (EE, SE)
    • 2012 (EE, SE)
    • 2012 Cluster (EE,SE)
    • 2012 R2 (EE, SE)

    Important

    For SQL Server to support TLS 1.2, certain client components and driver updates are required, as discussed inthis Microsoft article.

  • You do not need to create the database schema if you are installing or upgrading using the unified product installer. The unified installer performs this task automatically. 

To set up a SQL Server database and user

.Failed to execute the [excerpt-include] macro. Cause: [Error number 2 in 0: No wiki with id [confluencePage:page] could be found]. Click on this message for details.

Back to top

To configure TrueSight Server Automation databases for a non-English locale (optional)

This is an optional step. To use TrueSight Server Automation in a locale other than English, follow these guidelines:

  • Configure your TrueSight Server Automation databases using the settings recommended by your database vendor for that language.
  •  If the database is configured for a multibyte locale or a non-LATIN-1 locale, when you set up the database schema, run the master script that corresponds to the nchar character set.

Back to top

To install the SQL schema manually (not required when using unified product installer)

This section provides instructions for installing the SQL Server database schema manually.

Note

Do not perform this task if you installing or upgrading using the unified product installer. The unified installer performs this task automatically.


  1. Copy install scripts from the db_scripts directory in the main product .zip to a location that you can access from the SQL Server console. For information on the db_scripts directory, see Downloading-the-installation-files.
     The relevant scripts appear in the /files/configurations/dbscripts/sqlserver directory inside the TSSA<version>-<platform>64 installer zip package.
  2. Open a command prompt window.
  3. Change (cd) to /db_scripts/sqlserver.

  4. Run the master script that corresponds to the character sets for which your database is configured, using the following syntax:
    <master_script.bat> <db_server> <db_name> <bl_user> <bl_pwd>
    For example:
    sqlserver_master.bat QLDS0002 BLADELOGIC BLADELOGIC bmcAdm1n
    Replace the variables with the following values:

    Variable

    Value

    <master_script.bat>

    sqlserver_master.bat if your database is configured for char/varchar character sets or sqlserver_nchar_master.bat if your database is configured for nchar/nvarchar character sets

    <db_server>

    Name of the database server.
    If the server uses a nonstandard port, the server name and port number must be enclosed in quotation marks, as shown in the following example: "QLDS0002,1381"
    To use a named server instance, append the named instance, including the complete path, as shown in this example:
    sqlserver_master.bat <db_server>\<instance_name> <db_name> <db_user> <db_password>

    <db_name>

    Name of the TrueSight Server Automation database that you created while setting up the database

    <bl_user>

    Logon name for the TrueSight Server Automation database user

    <bl_pwd>

    BMC  Server Automation database user password

Note

When the master script runs, the following warnings might appear:

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'rsave_cond_result_subtree'. The stored procedure will still be created. Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'rsave_cr_group_result_subtree'. The stored procedure will still be created.

These warnings are expected and can be ignored.

Back to top

SQL database maintenance: Recommendation for gathering statistics


As with other products which use Microsoft SQL database, some performance problems in a TrueSight Server Automation environment can be caused by stale SQL statistics on the TrueSight Server Automation schema, due to changing data volumes or changes in column values. BMC strongly recommends that you gather statistics for the core TrueSight Server Automation database one time per week.

Use the EXEC sp_updatestats command to run the SQL server built-in procedure against all tables in the schema, to gather statistics and optimize the database. For more information on gathering statistics, see Microsoft documentation.

Warning

Gathering statistics is a resource-intensive task and you may experience a fall in database performance while executing this task.

You can also refer to the Health and Value Dashboard for additional statistics about the database server and information you can use for troubleshooting problems. To access the dashboard, see Using the Health and Value Dashboards.

 


 

Back to top

Where to go from here

Configuring-the-file-server

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*