More discussions in General Network ManagementWhere is this place located?
1 Reply Latest reply: Feb 6, 2012 7:25 AM by sean.martinez RSS

SQL Database capacity issues.  SQL Express > 10GB = Fail....

jhaegele
jhaegele Feb 6, 2012 6:29 AM
Currently Being Moderated

So I ran into an interesting issue (not really) about our SQL Implementation that is used for the Solarwinds.   In short, SQL Express cannot have a single database file over 10GB.  It looks like after about 5 months of usage, and a fairly sizable growth, we had hit a limit that we were not expected on SQL Express.  

Couple of Observations:

1 - NCM is now storing it's data within the main database or is it still separate?  Still trying to figure this one out.  

2 - Are we able to break different functions to separate databases?  Such as Netflow to one database, syslog to another database, general config to another database, poller information to another?  

3 - Anyone find any options to use another database, not MS, that can support this as well?  MySQL or Prosql?

I see there reference about breaking the database up over the WAN is not recommended, but how about locally, on the same DB server, just a different instance....

 

-Jay

  • 172 Views
  • Re: SQL Database capacity issues.  SQL Express > 10GB = Fail....
    sean.martinez
    sean.martinez Feb 6, 2012 7:25 AM (in response to jhaegele)
    Currently Being Moderated

    The 10GB Database size limit is a limitation Microsoft built into SQL Express 2008 R2, in earlier Express versions the maximum size was 4GB. You will need to move to another Edition of SQL. Please see the Microsoft SQL Edition Comparison. 

     

    1 - NCM is now storing it's data within the main database or is it still separate?  

    As of NCM 7.0.1, NCM is still in the ConfigMGMT database for the time being.

    2 - Are we able to break different functions to separate databases?  Such as Netflow to one database, syslog to another database, general config to another database, poller information to another?  

    You will not be able to break up the SQL Database.

    3 - Anyone find any options to use another database, not MS, that can support this as well?  MySQL or Prosql?

    We require Micorosft SQL for the Orion Family of products.

     

Actions

More Like This

  • Retrieving data ...