How does SQL Azure Database enable Physical Administration?
Although SQL Azure plays an active role in managing the physical resources of the database, the DBA plays a very important role in administering SQL Azure-based database applications. Using SQL Azure, DBAs manage schema creation, statistics management, index tuning, query optimization, and security administration (logins, users, roles, etc.). For more information about security administration in SQL Azure, see Managing Logins and Users in SQL Azure. Database administration in SQL Azure differs most from SQL Server in terms of physical administration. SQL Azure automatically replicates all data to provide high availably. SQL Azure also manages load balancing and, in case of a server failure, transparent fail-over. To provide this level of physical administration, you cannot control the physical resources of SQL Azure. For example, you cannot specify the physical hard drive or file group where a database or index will reside. Because the computer file system is not accessible and all dat
Related Questions
- Is Linked Server supported in SQL Azure? Can I enable Linked Server between on-premise SQL Server and SQL Azure servers or between two instances of SQL Azure servers?
- Is there a limit to the number of connections made to an SQL Azure database or server?
- How does SQL Azure Database enable Physical Administration?
