1 / 16

SQL Server 2000 Sys Admin

SQL Server 2000 Sys Admin. Jeremiah Curtis Engineering Services Jeremiah.curtis@infor.com. SQL Server. What is SQL? Overview http://www.microsoft.com/sql/evaluation/overview/default.asp SQL vs SQL Server Memory Limits (Maximum Capacity Specifications) Database Size 1,048,516 TB

Download Presentation

SQL Server 2000 Sys Admin

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. SQL Server 2000 Sys Admin • Jeremiah Curtis Engineering Services Jeremiah.curtis@infor.com

  2. SQL Server • What is SQL? • Overview http://www.microsoft.com/sql/evaluation/overview/default.asp • SQL vs SQL Server • Memory Limits (Maximum Capacity Specifications) • Database Size 1,048,516 TB • Up to 4 Processors (Standard) • Up to 2 GB of Memory (Standard) • Up to 32 Processors (Enterprise) • Up to 64 GB of Memory (Enterprise)

  3. Installed Programs • Books Online • Enterprise Manager • Query Analyzer

  4. Books Online • Actually Helpful!

  5. Installing • Should use “mixed mode” authentication • Collation • File Location • Service Pack 3a “Slammer”

  6. Enterprise Manager • Databases • DTS • Management • Replication • Security • Support Services • Meta Data Services

  7. Databases • Right Click options • View, Taskpad • Backup/Restore • Shrink Database • Properties • Tables • Open Table • All Tasks

  8. Tables • Open Table • All Tasks

  9. DTS • Import/Export From SX.e • View Package • Process of execution

  10. Management • SQL Server Agent • Backup • Current Activity • User Logging/Locks • Database Maintenance • Backups • Truncating Transaction Logs • SQL Server Logs

  11. Security • Logins • Authentication Modes • Windows vs SQL

  12. File Types • What files are used? • .mdf • .ndf • .ldf

  13. Query Analyzer • Login • T-SQL Language • Select the appropriate Database • Run SQL scripts here

  14. ODBC Setup • Admin Tools • System DSN

  15. Performance Tuning • RAID • Raid 0 • Raid 1 • Raid 5 • Raid 10 • File Growth • Percentage vs MB

  16. Transaction Logs • Files • Truncate • Monitor Growth

More Related