Its a robust and stable application. Works well on different os. Integration with other tool is pretty much simple. Database development is easy and does not require much knowledge to begin work on this application. Easily able to create new db objects like trigger, cursor, stored procedue, user defined functions, tables, views etc. This supports a large number of datatypes. Allows to store large scale databases.
Its tuning advisor helps us to provide the detail about optimization.
Execution plan helps us to review the query cost, cpu cost, scan, read count details efficiently.
Performance of application is awesome.
Tool is pretty much secure as per the need we can define the users role. Allows to encrypt/decrypt the sensitive tables' data.
Database availability is good enough. Data parallel processing is awesome and this support concurrent transaction efficiently.
Database reatoration and backup task are very simple. We can easily schedule the backups.
Application's installation takes more time and space on disk. Except these did not find any major issue.
We are using this application to manage our applications databases. Archiving the databases and scheduling the backups. Its highly secure and reliable application.
Automated the database backups(hourly, daily, weekly).