SQL Server Review

License price is lower than Oracle's

What is our primary use case?

The customer's MES system  use it.  The database system desgin as always on architecture.

Like Data guard in Oracle , always on contain double data and sync data by using transactions store in transaction log

How has it helped my organization?

It is easy to establish, and the license price is lower than that of Oracle.  

Otherwise, our customer could can replace primary databases from Oracle into MSSQL AG

Base on  windows cluster,  the always on no needs complicated config process.

Just click and click following  GUI interface.

What is most valuable?

table partition options,  that is very useful to separate unnecessary cost. 

For legacy data,  we can do partition swith out and store into flat files or old tables.

When it necessary, we can switch in back.

What needs improvement?

Horizontal partitioning.  

In that case,  cold , warm and hot data can be distributed into different database not only table partition located on different FGs .

For how long have I used the solution?

Three to five years.

What do I think about the stability of the solution?

Sometimes , when windows server suddently failed, the database still can be turn on when DB server started.

What do I think about the scalability of the solution?

When do "sp_rename" or "table rebuild" , the cluster index or non-cluster index no needs to rebuild at same time

How are customer service and technical support?

Customer always comes out many questions

Which solution did I use previously and why did I switch?

I have no choice. our customer choose MS SQL 

How was the initial setup?

 initial setup straightforward

What about the implementation team?

ordinary level

What was our ROI?

database administrator

What's my experience with pricing, setup cost, and licensing?

Migration local database into cloud

Which other solutions did I evaluate?

No, I  have to accepted it 

What other advice do I have?

subpartition is necessary

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment