Implementing workload management

You have read about control nodes and compute nodes in the preceding sections, and you will learn that you can add more compute nodes when your workload needs more power in the Scaling the database section. But keep in mind that adding compute nodes will also add cost to your bill at the end of the month.

Tip

Try and identify time slots where your database is not "hammered on" big time and either scale the database back down or, when you can afford to, hibernate it. You can save a lot of money by doing so. Development and testing environments are also good candidates for switching the database off when they aren't needed.

Fortunately, the Synapse product group has added some options to the database that will help you with optimizing the usage of a given compute environment before you need to scale the database. Workload management will enable you to set different priorities (workload importance) for different processes, to isolate...