BigFix Inventory with remote MS SQL server

Usage and Config Platform
1

Hi We are looking to use ILMT and or BigFix Inventory with BF 9.5.

  1. Would someone be able to advise what the pro/cons are for having a remote v local database?
  2. Are there any remote database configurations that are not supported?
  3. Is it easy to do any pitfalls? or advice? (Im not a MS SQL person)
2

I’m not a SQL guy either, but we have this setup and is running fairly well. The only thing I can think of to mention is the web app server still seems to get hit hard when doing some of the processing. Other than that I haven’t had any issues with it yet.

3

Hello

IBM has a capacity and planning guide you may find useful.
IBM BigFix Version 9.x: Capacity Planning, Performance, and Management Guide
http://www.ibm.com/software/ismlibrary?NavCode=1TW10EP0H << requires IBM ID.
http://www-01.ibm.com/support/docview.wss?uid=swg27048326

4

Good to know. Thanks

5

Hi, Just downloading - some bedtime reading :slight_smile:

6

Had a quick look - yes looks like a really good document but very little info on MS SQL

7

I take that back it does have info on MS SQL.

8

Depending on the number of clients you have, a separate database server would allow that processing to be moved off the BFI/ILMT server, allowing for better scalability. BFI/ILMT processing would be separated from database calls. Of course, you now have an additional network connection that has to be maintained, although this connection should always be very local.

If you choose Windows, you must use SQL Server. If you choose Linux, you must use DB2. Anything else is not supported. Other DBMS are not supported.

It doesn’t hurt to have some SQL Server knowledge but you don’t need to be a full fledged DBA to support it. I have ILMT 9.2.4 (soon to be 9.2.5) running on Windows & SQL Server and it’s been very reliable. I don’t recall running into any pitfalls when setting the server up.

-Mark