I have recently noticed that we have many instances of SQL Standard in our environment, but not Enterprise. What would be the real benefit of Enterprise over Standard? I am concerned we are may not be getting the full benefit that a company truly needs.
@xypher, it really all comes down to the cost/benefit analysis. Enterprise Edition is very costly. If you are not installing SQL on a massively powerful server then the fact of Enterprise Ed supporting more ram and processors over standard doesn't matter. If you don't need compression, partitioning, etc of Enterprise then Standard is good enough. Back with SQL 2000 only Enterprise would support log shipping so many companies were forced into Enterprise for HA and DR. With 2005 and above Mirroring and Log Shipping are a feature set of Standard. The link that @kenJ provided has the answers you are looking for. Mainly with @williamD's link of [Features](