My question is, do I have to have the SQL install located on the same server as the BES server?
We try and keep our SQL installations to a minimum, so exporting the db to an existing SQL instance would be preferable for several reasons.
I haven’t been able to find any information on this particular configuration as most seem to have a SQL instance on their BES server.
I am not concerned about performance as the instance I want to move the db to is a overpowered/underused server that could accommodate much more load than our BES db would put on it.
I haven’t done it myself but have seen the option to install BES using a remote DB. It will probably be in the BES Admin documenation what you need to do.
You can use a different system for the database, but we don’t recommend using a shared database… The reason is that BigFix writes very rapidly to the database and even high-powered databases will often struggle with the load… What tends to happen is that other applications will interfere with BigFix performance or BigFix will interfere with their performance…