This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
MainView Threshold Advisor 1.0.00
MainView Infrastructure 6.1.00
Can Threshold Advisor use SQL Server Express?
I have started looking into the use of Threshold Advisor and it appears that we have to purchase an MS SQL Server or Oracle license to use it. SQL Server Express is free for a small database use, so we would avoid this cost.
I will only be testing the product on a test system and do not need a fully functional database, so SQL Server Express would be ideal, if it is supported.
Threshold Advisor uses the services of BMC's CDB (Capacity DataBase) Services, and SQL Server Express may be used as the backend database for CDB.
However, this is only really appropriate for a test system or a trial. For full production, the full-function MS SQL Server or Oracle is recommended.
SQL Server Express 2008 R2 and 2012 limits the database size to a maximum of 10 GB, will only use one processor even if more are available and is limited to a maximum of 1 GB of memory usage, so you may be able to run with it with decreased performance, depending on your usage of Threshold Advisor.
- MainView Infrastructure