Sybase Database Administrator's Handbook (1995)

1. Standard Server and Server. Machine Environment. You Are Not Alone Anymore. The Multiserver Environment. Why You Should Have a Standard Configuration. Standard for Overall Environment. Standard Configuration for All Server and DBA Machines. Standard Configuration for Servers. 2. Replication Server. Overview. What Replication Server Does. What Replication Server Doesn't Do. Example of the Process of Replicating Data. Configuration Issues. Installing Replication Server. Creating a Subscription. Users and Passwords. How Replication Server Links with SQL Servers. Affects on Existing and New Applications. Capacity Planning. Administration Using Replication Server Manager. Failure Modes. Function Strings. 3. Installation of SQL Server from Scratch. Preparing for Installation. Sybconfig for SQL Server. Sybinit for SQL Server System. Post sybconfig (sybinit for System 10). Sybconfig (sybinit for System 10) Errors. 4. Physical Server Design. Physical Disks. Raw Partitions vs. File Systems. SQL Server Logical Disk Devices. Disk Partitioning. Disk Controllers. Initializing Server Devices. Final Notes on disk init. Database Segments. Mirroring Server Devices. How to Layout the Devices and Segments of a Server. Summary. 5. Documenting a Server. The Servermap and Why You Need. Generating Servermap for Existing SQL Server. Generating Servermap for New SQL Server. Server Configuration. Database Usage and Relative Importance. Server Health. Server Machine Configuration. The Database System. 6. Physical Database Implementation. Transaction Log on Separate Server Device. Transaction Log Not on Separate Device. Sizing the Transaction Log. Placing a Database on Disks and Controllers. Placing Databases on Disks and Controllers. Mirroring Priorities. Why You Should Be Hesitant to Add Database Space. 7. The master Database Is Special. The master Database and Master Device. Sizing the Master Device. The logsegment of the master Database. Master Device Name and Mirroring. Master Device and disk init. Master Device and Default Server Disk Devices. Loading a Database Dump of the master Database. Moving Master Device to the Larger Partition. Clearing Server Configuration in master Database. 8. SQL Server Recovery. Recovery Planning Revolves Around the Cost of Downtime. The Database is Nothing without the Transaction Log. Recovery Is Transaction Based. Standby Server Strategies. Master Database Is Not for Users. The Use of dbcc. Mirroring. Archiving. More Server Devices Are Better. Recovery Notes. Database Dumps. Transaction Log Dumps. Logical Dumps and DataTools SQL BackTrack. Recovery Matrix. 9. Performance and Tuning. Theory Is Nice. What You Can Do in the Real World. Indexes and Queries. Spreading Segments Over Server Devices. Spreading Individual Tables. Archiving. Decision Support Server. Standard Set of Application Transactions. SQL Monitor. SQL Server Performance Tools. Application-Transparent Server Tuning. Preventing Downtime. Servermap and Performance and Tuning. 10. Capacity Planning. The Overall Database System. The Individual Server. Real-World Example. Capacity Planning for the Database System. 11. Operational Details of SQL Server. Interfaces File. Communication Among Servers. Creating Stored Procedure from SQL Script or defncopy Output. What sysusages Means. Reading the Errorlog. Impacts of Creating a New Database. Modifying System Tables Manually. bcp Command. Full Transaction Log or Other Segment (1105 Error). 12. Database Administration Versus Database System Size. Small Database Systems. Large Database Systems. Very Large Database Systems. Summary. 13. Upgrading SQL Server. Installation Guide, Release Notes, and EBF Cover Letter. Sybase Technical Support. Risks of the Upgrade Process. EBF Upgrades. Version Upgrades. Preparing to Upgrade 4.9.x to System. Upgrading 4.9.x to System 10. Post Upgrade 4.9.x to System 10. Actual Upgrade Output 4.9.x to System 10. Regressing from Failed System 10 Upgrade. Dependencies. 14. Transitioning to System 10. System 10 Changes to SQL Server. Transition to System 10 Won't Happen All at Once. SQL Server Upgrade Dependencies. Changes that Affect Existing Applications. Changes that Affect DBA. Compatibility with Other Sybase Products. Server Login Passwords. Server Login 'sa' versus Server Logins with sa_role. Backup Server. 15. Scripts. Dump Database Transaction Log (dumplog). Dump Databases for SQL Server 4.9.x (dumpdb). Load Databases for SQL Server 4.9.x (loaddb). Update statistics on All Tables (update_statistics_all_tables). Dump Commands to Recreate Databases (dump_db_create). Run dbcc Checks (checkdb). Dump Data from System Tables (dump_systables). Create Stored Procedure to Generate Database Creation Script (p_dbcreate). Create Stored Procedure to Check Mirrors (p_mirror). Create Stored Procedure to Output Device Space (p_devspace). Create Stored Procedure to Output All Segments on Devices (p_servermap). Dump Databases for SQL Server System 10 (dumpdb_sys10_tape_disk). Load Databases for SQL Server System 10 (loaddb_sys10). Server Startup Script RUN_<servername). 16. Recommended Reading. SQL Server Books. SQL Books. Database Design/Tuning Books. UNIX Books. System Administration Books. Data Modeling Books. Magazines. General. Index.