Administering Adaptive Server includes tasks such as:
Installing Adaptive Server and Backup Server
Creating and managing Adaptive Server login accounts
Granting roles and permissions to Adaptive Server users
Managing and monitoring the use of disk space, memory, and connections
Backing up and restoring databases
Diagnosing system problems
Configuring Adaptive Server to achieve the best performance
In addition, System Administrators may have a hand in certain database design tasks, such as enforcing integrity standards. This function may overlap with the work of application designers.
Although a System Administrator concentrates on tasks that are independent of the applications running on Adaptive Server, he or she is likely to be the person with the best overview of all the applications. For this reason, a System Administrator can advise application designers about the data that already exists on Adaptive Server, make recommendations about standardizing data definitions across applications, and so on.
However, the distinction between what is specific to an application is sometimes a bit “fuzzy.” Owners of user databases will consult certain sections of this book. Similarly, System Administrators and Database Owners will use the Transact-SQL User’s Guide (especially the chapters on data definition, stored procedures, and triggers). Both System Administrators and application designers will use the Performance and Tuning Guide.