How can we create an optimistic maintenance plan for the below mentioned scenario -
- i do have one 1 TB of Database size
- 500 GB of Transaction log file
- my database is in replication mode with 7 publications and approx. 50 Subscription
- Accessing Concurrent users 400 users
- Transaction occurs 400 /sec
- Batches 400 / sec