Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

A few Sql questions

Hey guys, just trying to prepare for our Solarwinds installation and a few questions have come up, mainly:

should we go with sql express or sql server, and why?

about how big does the DB get? ( i know this is vague but given different amounts of elements being monitored but just trying to get an idea on how much space we should allocate for it)

thanks

Find more posts tagged with

Accepted answers

All comments

pacetti

apscherz,

Do you have any idea how large your monitored network is? What kind of objects are you looking to monitor?

Generally:

we recommend using a full SQL Server installation, due to the 4GB limit on SQL Express DBs.
a single NPM polling engine, deployed as outlined in the System Requirements can handle up to ~8000 objects.

For more information, see "Orion Server Hardware Requirements", "Orion Server Software Requirements", "Requirements for the Orion Database Server (SQL Server)", and "Server Sizing" in the SolarWinds Orion NPM Administrator Guide.

HTH,

netlogix

I am not positive on this, but at one time the SQL light version would only allow you to use one processor/core. Depending on how many nodes you have, that can really slow down the SQL performance,

Donald_Francis

No question, you should use the full version. Even if you could get away with it now you may need it later. Moving it is not the worst thing in the world it would just be more to do.