What's Documented

SQL Power Doc collects an exhaustive set of information about SQL Server instances and their underlying Windows OS. SQL What's collected depends on the version and edition of SQL Server, version and edition of Windows, and runtime parameters.

Here's everything SQL Power Doc can document:

SQL Sever Services

  • Service Details for all installed SQL Server services

Database Engine

Configuration

  • General Details
  • Memory
  • Processors
  • Security
  • Connections
  • Database Settings
  • Advanced Settings
  • High Availability (Clustering & AlwaysOn)

Security

  • Logins
  • Roles
  • Credentials
  • Audits
  • Audit Specifications

Server Objects

  • Endpoints
  • Linked Servers
  • Startup Procedures
  • Server Triggers

Server Management

  • Resource Governor
  • SQL Trace
  • Trace Flags
  • Database Mail
    • Accounts
    • Profiles
    • Security
    • Configuration

Databases

  • Configuration
    • General Details
    • Files
    • Filegroups
    • Options
    • Change Tracking
    • Permissions
    • Mirroring
    • AlwaysOn
  • Database Objects
    • Tables (Properties, Checks, Columns, Foreign Keys, Full Text Indexes, Indexes, Statistics, Triggers)
    • Views (Properties, Columns, Full Text Indexes, Indexes, Statistics, Triggers, Definition)
    • Synonyms (Properties, Definition)
    • Programmability
      • Stored Procedures (Properties, Parameters, Definition)
      • Extended Stored Procedures (Properties)
      • Functions (Properties, Checks, Columns, Indexes, Parameters, Definition)
      • Database Triggers (Properties, Definition)
      • Assemblies
      • Types
        • User Defined Aggregates (Properties, Parameters)
        • User Defined Data Types (Properties)
        • User Defined Table Types (Properties, Checks, Columns, Indexes)
        • User Defined Types (Properties)
        • XML Schema Collections (Properties, Definition)
        • Rules (Properties, Definition)
        • Defaults (Properties, Definition)
        • Plan Guides (Properties, Definition)
        • Sequences (Properties)
  • Service Broker
    • Message Types
    • Service Contracts
    • Queues
    • Services
    • Routes
    • Remote Service Bindings
    • Priorities
  • Storage
    • Full Text Catalogs
    • Full Text Stop Lists
    • Partition Schemes
    • Partition Functions
  • Security
    • Users
    • Application Roles
    • Database Roles
    • Certificates
    • Schemas
    • Asymmetric Keys
    • Symmetric Keys

SQL Agent

Configuration

  • General Details
  • Advanced settings
  • Alert System
  • Job System
  • Connections
  • History

Jobs

  • General Details
  • Steps
  • Schedules
  • Alerts
  • Notifications

Alerts

  • General Details
  • Reponses
  • Options
  • History

Operators

  • General Details
  • Notifications
  • History

Windows OS

Machine Information

  • BIOS
  • Physical Memory
  • Processors
  • Sound Devices
  • System Enclosure
  • Network Adapters
  • Printers
  • CD\DVD Drives
  • Disk Drives
  • Tape Drives
  • Video Cards

OS Information

  • Time Zone
  • Event Logs
  • IPv4 Routes
  • Page Files
  • Registry Settings
  • OS Details
  • Power Plans
  • Startup Commands
  • Running Processes
  • Services
  • Shares
  • Local Users
  • Local Groups
  • Desktop Sessions

Software

  • Installed Applications
  • Patches

Last edited Apr 10, 2013 at 8:11 PM by kendalvandyke, version 4

Comments

dkstanger Feb 6 at 5:59 PM 
Hi Kendal, This is a great tool and solves a lot of problems for us. By chance, any thoughts or plans to add a feature to allow our own documentation? For example, we want to describe the purpose of a server. We also want to describe the purpose of each database and its SLA.
Thanks,
Darren