Solid Queue (by default actually) uses a second, segregated database for the queue. You can scale it independently of your app database.
Managing multiple DB instances across multiple hosts requires a lot more effort, configuration and doubles your hosting costs vs running Redis on the same host with Sidekiq IMO.