Database growth - SQL Express

I'm planning a NPM installation for a customer for monitoring about 400 nodes, 2 interfaces per node and 40 volumes. Historical data will be kept for 2 yrs.

Is it advisable to use SQL Express with 4GB limitation with default polling intervals?

THX

Klaus

Find more posts tagged with

sql_express_2005

Accepted answers

All comments

bleearg13

I would recommend MS SQL Server, not SQL Express. You will run into space issues in a couple of months, if not before that. Keeping historical data for 2 years will use up a lot of space, assuming you mean all historical data such as alerts, traps, and syslogs.

Oliver_White

HI Klaus,

It would be advisable to start with a proper SQL server due to the fact youwant to store data for 2 years. You will hit the limit of 4 GB eventually and then need to upgrade the SQL. You will avoid additional steps when starting with SQL Standard or Enterprise.

I hope this has helped.

Kind Regards

Oliver

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of