Cant seem to find anything that relates to server spec for sql server when using multiple SW products, only individual requirements.
We have NCM for 500 devices, and are will have approx. 4000 interfaces for NPM and perhaps 400 ish for NTA. We have a dedicated server for NTA flow storage which is up to spec, so just need a suitable SQL server.
Id read somewhere, although, cant remember where id seen it, nor can I find it again... that SQL server spec should be 3 pairs of raid 1 disk (one pair each for OS, Logs & DB). I think we may only have some 4 disk dual quad core xeons with 16gb ram kicking about, so thinking of trying it out on one of these, and see how we go...
Anyone point me in right direction?
With dedicated flow storage in use, that quad Xeon box is in the right range to handle 4000 interfaces at stock polling intervals without issue. RAID1+0 is preferred, but owing to the number of spindles you have that may prove difficult to do and separate out spindles for OS / logs.