Adaptive Server administration tasks include:
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 assist with certain database design tasks that overlap with the work of application designers, such as enforcing integrity standards.
Although a system administrator generally concentrates on tasks that are independent of the applications running on Adaptive Server, he or she is likely to have the best overview of all 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 unclear. Owners of user databases may consult certain sections of this book. Similarly, system administrators and database owners will use the Transact-SQL Users Guide (especially the chapters on data definition, stored procedures, and triggers). Both system administrators and application designers will use the Performance and Tuning Series.
