Azure Synapse Analytics
-
Backup on Pause/Resume
At the moment the automated backup process take place every 8 hours unless the database is paused. Upon resumption of the database, it appears that it has to be online for 8 hours before the next backup is taken.
If resuming and then pausing the system again it is possible to go for a long duration without backups. Could you please evaluate the potential of taking an automatic backup either when the database is paused or resumed.
14 votesWe are actively exploring ways to enable event-driven backups. Currently this scenario can be addressed by User Defined Restore Points which is on our road map for this calendar year. Stay tuned and thank you for your patience.
-
Expand size of LABEL in query logs
The LABEL column in the sys.dmpdwexec_requests DMV is limited to 255 characters.
This field needs to be much larger to store rich metadata/context of some queries.
4 votesThank you for all the feedback folks. Unfortunately this is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update.
- Don't see your idea?