Clarity

  • 1.  Is it possible to store clarity test and prod db on the same db server on ms sql?

    Posted Aug 12, 2014 10:38 AM

    Hello Team,

     

    We want to store clarity test and production environment DB on the same MS SQL db server and same instance.

    Is it possible to do it?

    Can we use different DB names instead of "niku"?

     

    Best Regards.



  • 2.  Re: Is it possible to store clarity test and prod db on the same db server on ms sql?

    Posted Aug 13, 2014 02:09 AM

    Hi Mustafa,

     

    Its always best to have a separate dedicated DB server for your production database for optimal performance. I guess storing both the Prod and Test DBs in one DB server, in the same instance, can lead to serious performance issues in your production environment.

     

    But technically, this should be possible as you can see from The specified item was not found.

     

    Regards,

    Georgy



  • 3.  Re: Is it possible to store clarity test and prod db on the same db server on ms sql?

    Posted Aug 13, 2014 04:41 AM

    Yes easily "possible", just not normally "recommended".

     

    Simple config in the NSA/CSA - on the database tab you just tell clarity where the relevant database is - clarity does not really care where the database is, just as long as it can find it!



  • 4.  Re: Is it possible to store clarity test and prod db on the same db server on ms sql?

    Posted Aug 13, 2014 05:13 AM

    not normally "recommended" relates to one of the instances being prod and that is presumably because of the risk of getting it messed up and down time while restoring. With test and training the effect of the risk is lower. That is not limited to MS SQL, but applies to Oracle as weel.

     

    If you read the installation guide it says something like that you can name the database whatever you want, but the database user name has to be "niku"

    Read it.

     

    If you go ahead and have two instances on the same db server are you going to have one or two app servers? You can have two instances on one app server if you differentiate the with all different ports.