4 Replies Latest reply on Mar 12, 2018 8:24 AM by jeremymayfield

    Database and Solarwinds Installation

    HEMANTHKUMAR S

      Is this possible to install database and modules to install in a single server. If not why, If yes how you will segregate.?

        • Re: Database and Solarwinds Installation
          saeron

          Yes that possible to install all modules in a single server with database.

          But there is possibility to suffer from weak performance when number of modules or number of monitor elements and node increase.

          So for scalability purpose its better in deployment phase you separate database and application in two different server.

          Also its better to install your database on a physical server.

          Also for better performance you should install additional pollers and additional website for delegation of authority for specific rules to this servers.

          2 of 2 people found this helpful
          • Re: Database and Solarwinds Installation
            neomatrix1217

            It's actually in the requirements to install the SQL DB onto another server and as saeron stated you will suffer from performance issues down the road.

             

            The Orion server and the SolarWinds Orion database must use separate servers.

            If you install on a virtual machine, you must maintain your SQL Server database on a separate, physical drive.

             

            Orion Platform requirements - SolarWinds Worldwide, LLC. Help and Support

             

             

            https://support.solarwinds.com/Success_Center/Orion_Platform/Migrate_the_SolarWinds_Orion_SQL_database_to_a_new_server

            1 of 1 people found this helpful
            • Re: Database and Solarwinds Installation
              leigham martin

              Hello,

               

              Dont install on the same box!!!

               

              I have SAM & WPM running on a virtual machine and on the initial stages of implementing SolarWinds into our infrastructure i ignored the recommendations and went with SQL and App all on 1 server.

              Trust me, you'll spend more time on plans to move SQL to another server than actually installing SQL & SolarWinds on the same box.

               

              I suffered from huge performance problems when using SolarWinds when i had it all on one server, have your SolarWinds Database on a dedicated SQL Server.

              It works well with a virtual machine platform just make sure the boxes have enough juice. I guess it depends on your storage backbone too.

               

              My setup;

               

              ESXI 5.5

              EMC VNX storage on Gold Tier disks (SSD & SAS)

               

              SAM/WPM/Orion:

              10 vCPU (it uses around 70-80% of this, 90+% on heavy loads)

              16GB vRAM

               

              SAM/WPM/Orion Additional Poller:

              4 vCPU

              12GB vRAM

               

              SQL Server:

              8 vCPU (Uses around 50-60% on average)

              26GB vRAM - 22GB allocated to SQL Server Instance

               

              See below image for amount of elements being monitored;

               

              Hopefully my info will give you a clearer idea on what resources to allocated to the servers you will host your SolarWinds install on.

               

              Regards,

               

              L.

              1 of 1 people found this helpful
              • Re: Database and Solarwinds Installation
                jeremymayfield

                I actually ran for years this way, it was 2017 when i separated.    It all just depends on the size of your site and nodes. 

                1 of 1 people found this helpful