When I worked in Australia we had a client with ~1.5tb database in SQL Server, largest main table was about 2.5b records. Had no problem returning joined record

When I worked in Australia we had a client with ~1.5tb database in SQL Server, largest main table was about 2.5b records. Had no problem returning joined records in low ms times. Wouldn't be good if it had really high traffic but we wrote about ~1-2m records per day into the tables without issue reading it out. SQL Server can perform. But requires a lot of massaging. --- We tried using DynamoDB for logging, not sure why but the team had trouble with document sizes, write limits, in the end it was growing and going to cost more than SQL Server, was replaced with logging to PostgreSQL with much more flexibilty and runs on a t2.micro instance without issue.