Network Management

Locating your Orion database properties and storing your DB files

This article describes finding the Orion DB files location and provides the recommended best practice to store your database files for optimum performance in a production environment. This article is part of the Quick Orion Database Health Check Guide.

First published date

11/29/2018 10:38 PM

Last published date

10/9/2019 6:59 PM

Overview

This article provides information on how to find the Orion DB files location, and provides the recommended best practice to store your database files for optimum performance in a production environment .  

This article is part of the Quick Orion database health check guide .

Product section

Orion Platform

Resolution

  1. Open the SQL Server Management Studio. 

    You can download a free trial version from the Microsoft Developers Network website. 

  2. Locate the name of your SQL database server. If you do not know the name of the server:
    1. Open Database Manager.
    2. Click Add Orion Server.
    3. Expand the menu tree. The server highlighted in bold text is your database server.
    4. Record the server information.
    5. Close Database Manager. 
  3. Connect to your SQL database server.

    In the Connect to Server window, complete the fields and click Connect.

    image.png

  4. In the Microsoft SQL Server Management Studio window, open your Orion Database properties.

    In the Object Explorer, right click the Orion database and select Properties. 

    image.png

  5. In the Database Properties window, view the files and their locations. 

  6. Ensure that your DB files are stored properly.

Storing your DB files 

SolarWinds does not recommend Locating your Orion database properties and storing your DB files  (C:\ drive) or single disk array within a production environment. However, you can divide the load between multiple disks to balance the load between the arrays. 

Store all DB files on a local drive or single disk (not recommended) 

The following table lists the database name and its corresponding file ID, and file name for this configuration. Note that all databases are stored on the D:\ drive. 

Name

File ID

File name

Oriondb

1

D:\Program Files\Microsoft SQL
Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Oriondb.mdf

Oriondb_log

2

D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Oriondb_log.ldf

Oriondb_FG1

3

D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Oriondb_FG1.mdf

Oriondb_FG2

4

D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Oriondb_FG2.mdf

Oriondb_FG3

5

D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Oriondb_FG3.mdf

Oriondb_FG4

6

D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Oriondb_FG4.mdf

Divide the load between multiple disks (recommended) 

 

The following table lists the database name and its corresponding file ID, and file name for this configuration. Note that all databases are stored on multiple drives. 

Name

File ID

File name

SolarWindsOrion

1

E:\data01\Data\SolarWindsOrion.mdf

SolarWindsOrion_log

2

F:\Log\SolarWindsOrion_log.ldf

SolarWindsOrion_FG1

3

D:\data01\Data\SolarWindsOrion_FG1.mdf

SolarWindsOrion_FG2

4

D:\\data01\Data\SolarWindsOrion_FG2.mdf

SolarWindsOrion_FG3

5

E:\\data01\Data\SolarWindsOrion_FG3.mdf

SolarWindsOrion_FG4

6

E:\data01\Data\SolarWindsOrion_FG4.mdf

SolarWindsOrion_log_2

7

T:\Log\SolarWindsOrion_log2.ldf