The question you posted, which was deleted, had several significant issues which did not make it fit for the StackExchange format. It therefore was deleted, with commentary from @RoryAlsop (plus a system-generated note) explaining why, because there was no foreseeable way to edit it into something which would match our format.
That your question appeared to be a product recommendation query is probably not the only reason it was closed or deleted, but unfortunately the system only displays the majority reason when a question is closed.
Here are some issues that I see:
Off-Topic: Product Recommendation
The intent of this site is to host questions and answers which are generally useful to the Internet population at large, and which will remain so for a reasonable length of time. Asking for a specific product recommendation to fit your particular needs will most likely result in answers that are only really beneficial to you. Further, as technology does quickly progress - especially in the realm of computers, and even more so in the realm of security - answers to such questions quickly become out-dated.
Aside from the often subjective nature of product recommendations in general, you also asked for opinions on how certain systems measure up against one another. This is likely to result in a lot of discussion and debate amongst users, which is not what this site is intended for.
You question really was kind-of all over the place. At any given point in the post, you're asking one or more of several questions:
- Is anyone on here a Cisco reseller?
- What firewall should I use?
- What antivirus should I use?
- What IPS should I use?
- How can I implement a security solution, while maintaining maximum bandwidth, for 10 site-to-site VPN connections?
- How does product X compare to product Y?
These are way too many questions for one thread in the StackExchange format, and most of these questions wouldn't even be permitted if they were submitted individually anyway.
Unclear What You Are Asking
A comment on the question demonstrates that, even if Product Recommendation questions were on-topic, there was not sufficient information in the question for it to be properly answerable.
What's your traffic utilization look like? Peak/sustained/minimum bandwidth? Also be aware there are database-specific application firewall appliances out there, commercial and open source. It may make sense to purchase something small like a Fortigate 80c for the office, and a GreenSQL box for the server. – RI Swamp Yankee
Generally, the first step for a question that doesn't appear to fit the StackExchange format is for it to be put on hold. This allows the asker an opportunity to clarify their needs and rephrase the question in a way that it can fit this site.
If a question remains on-hold for a certain duration, its status is changed to closed. Essentially, on-hold and close are the same thing. The on-hold term is just used initially to indicate that this question has a fair chance of being re-opened if modified quickly. Closed means that the asker has had a reasonable amount of time to modify it, but either has not cared to or has not been able to meet the StackExchange standards in that time.
In either situation - on-hold or closed - a question can be re-opened if it is changed to suit the StackExchange format. All it takes is a few votes from high-reputation users, or a single action by a moderator.
However, in extreme cases - like this one, where the question fits nearly every closure reason there is - a question may instead be deleted. This is reserved for a few, relatively rare, scenarios.
- The question is spam.
- The question is hateful or abusive, and otherwise serves no constructive purpose.
- Though not spam or offensive, there is no reasonable expectation that this question can be modified in a way to fit the StackExchange format and quality standards.
Your question clearly fit the last of those scenarios. Part of the reasoning for this was explained in the close reason tagged to the question, and the comments. I hope I've more clearly outlined any other aspects which may have not yet been covered.
If anything is still unclear, I suggest perusing the Help Center. There are many useful bits of information in there, including articles on how to ask a question here, what is and isn't on-topic, and reasons why questions may be closed and/or deleted. Browsing other questions on Meta, regarding question closure or deletion, may also be useful to you.