SQL Server Administration

Here you will find links to articles and resources concerned with SQL Server Administration

• SQL Server Configuration
  • Generic
    • How to determine proper SQL Server configuration settings
    • SQL Server 2005 Performance Audit : SQL Server Hardware Configuration Checklist
  • Memory Managment
    • Memory Management Architecture
    • Memory Configuration – AWE, PAE the /3GB Swith, MAX and MIN settings all discussed here.
  • Physical Storage
    • SAN Configuration – Disk Partitioning
    • SAN Best Practices
    • Should you store image files in SQL Server or the Filesystem?
    • Disk Alignment Best Practice
    • Monitoring Drive and Database Storage
    • Muli-Tenant Data Architecture
    • RAID Calculator

• SQL Server Clustering
  • SQL Server 2005 Clustering White Paper
  • Setting up a Windows Cluster using Virtual Servers
• SQL Server Reference Diagrams
  • SQL Server 2005 System Views Map
  • SQL Server 2008 System Tables Diagram