• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

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
    • CPU
      • SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies
      • SQL SERVER – CXPACKET – Parallelism – Usual Solution – Wait Type
      • MSDN Thread discussing NUMA/MAXDOP settings in newer technology and considerations for Denali
    • Memory Managment
      • Memory Management Architecture
      • Memory Configuration – AWE, PAE the /3GB Swith, MAX and MIN settings all discussed here.
      • Suggested Max Memory Settings for SQL Server 2005/2008
      • Do I have to assign the Lock Pages in Memory privilege for Local System?
    • 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
      • Disk Performance Hands On – This is Part 8 in an ongoing series on disk performance from Kendal Van Dyke. Compares the various RAID levels.
      • SQL Server Urban Legends Discussed – The number of threads per file myth.
      • SQL Server 2000 I/O Basics
    • Indexes
      • Inside sys.dm_db_index_physical_stats
      • Storage Internals of Non-Clustered Indexes
        • T-SQL Tuesday #010: Little Known Index Facts – Shows how the clustering key is stored differently in UNIQUE and non-unique nonclustered indexes.
        • Geek City: Nonclustered Index Keys
  • SQL Server Clustering
    • SQL Server 2005 Clustering White Paper
    • Setting up a Windows Cluster using Virtual Servers
    • Step-by-Step: Configuring a 2-node multi-site cluster on Windows Server 2008 R2 – Part 1
  • SQL Server Reference Diagrams
    • SQL Server 2005 System Views Map
    • SQL Server 2008 System Tables Diagram

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy