Βασίζομαι στον Παναγιώτη όταν λέει ότι πρέπει να κάνουμε λίγο υπομονή για να δούμε εργαλεία προσαρμοσμένα στο azure.
Είχα και εγώ κάποιες απορίες σχετικά με DBA tasks και SQL Azure. Τις έχω συζητήσει με τον Παναγιώτη μέσω MSN.
Οι απορίες μου δημιουργήθηκαν από ένα email που πήρα από τον Paul Randal(www.sqlskills.com) όπου ανέφερε σκέψεις και Limitations (που υπάρχουν αυτή την στιγμή) στο SQL Azure.Τις παραθέτω αυτούσιες παρακάτω.
_________________________________________________________________________________________________
The database size limit is 50GB
You can’t use BACKUP and RESTORE – only export the data or copy it to a new Azure database (which defeats the purpose of having off-site backups)
You can’t do auditing or use transparent data encryption
You can’t use replication or database mirroring to maintain your own redundant copy of the data (although they do keep redundant copies for you)
You have to rely on someone else’s high-availability and disaster recovery strategy (and just this morning, Amazon Web Services was down – along with everyone making use of them). SQL Azure provides a 99.9% availability SLA, with a 10% credit if it drops below that in any month, and 25% credit if it drops below 99% in any month. Still, 8.76 hours of downtime per year isn't too bad for many customers.
There’s no facility for managing very large databases (i.e. the ability to create filegroups and use partitioning)
There's no support for CLR, Full-Text, or Service Broker
You can't really do performance analysis and tuning (like running profiler, for instance)
_____________________________________________________________________________________________________
Νικόλαος Καντζέλης
BSc, MSc, MCAS, MCPD, MCITP, MCTS,MCP, MCT