Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 1370 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL recommendation - local or remote

SasiSan

My servers are virtualized.  Have a dedicated SQL Server blade with a SQL Server 2008R2 instance and SQL 2012.  SOPHOS server is in the same blade with fiber channels connecting.

Why would I install an express copy of SQL on the same machine as the Enterprise console? (vendor recommending)

Thanks in Advance for the experience opinions.

:40183


This thread was automatically locked due to age.
  • 0

    HI,

    The advantages to using a dedicated SQL box is largely performance. It may also ease administration and for a SQL team to own the resposibility of keeping the database running in top shape.

    The downside is the reliance on another computer and network connectivity.  It also makes upgrades a 2 step process.  I.e running the installer on the database computer and then on the management server.  Mayb need to involve 2 teams and increase change controls, etc...

    How many clients are you looking to manage as this is probably the question that will ultimately decide it?

    You can always move the database to the SQL server later if scalability  becomes an issue.  

    If I had less than 2000 computers to manage I'd just install the latest SQL Express version locally and use that.  

    Regards,

    Jak

    :40197
  • 0

    Hello SasiSan,

    having the database local simplifies future upgrades and migrations - that's why it is recommended. The database has no special demands, judging from my installation for a few thousand endpoints it doesn't cause much load on the VM except memory. It also has no special requirements in terms of database management.

    Just see that Jak more or less said the same (but more detailed and with better wording) - so I must be right :smileywink:

    Christian

    :40201