ApexSQL DBA includes all 6 of ApexSQL’s server management tools which currently include ApexSQL Audit, ApexSQL Backup, ApexSQL Log, ApexSQL Monitor, ApexSQL Recover and ApexSQL Restore.
Major Features of ApexSQL DBA
1.Performance
Baselining
Wait stats
Deadlock analysis
Slowest queries
Alerts
2.Auditing
Repository
Fault tolerance
Select auditing
Audit reports
Security auditing
Tamper resistance
3.Backup
Policy management
Backup validation
Log shipping
Restore scheduling
Centralized management
Agent deployment
4. Restore
Backup restores
Transaction log restores
Point-in-time
Compressed backup
Installation Instructions For Windows
Note: How to find PublicDNS in AWS
Step 1) RDP Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows instance on AWS Cloud
Connect to the virtual machine using following RDP credentials:
- Hostname: PublicDNS / IP of machine
- Port : 3389
Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .
Step 2) On the Start page, type ApexSQL DBA and then click on ApexSQL DBA
Step 3) Other Information:
1.Default installation path: will be on your root folder “C:\Program Files\ApexSQL”
2.Default ports:
- Windows Machines: RDP Port – 3389
- Http: 80
- Https: 443
Configure custom inbound and outbound rules using this link
