Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.


  • Presentation
  • Question
  • Answer

Tags
#Agile #Docs #Powershell #SQL
Question
What to document for SQL SRV ?
Answer

At a minimum, I’d say you need to document the following for every server:

  • Machine information
    • Memory – Total memory, available memory.
    • CPU – Amount of CPUs, amount of cores, architecture
    • OS – Architecture, version, service pack, build
    • Disks – Disk, name, size, free space
  • SQL Server engine
    • Configuration – Min and max memory, clr enabled, xp_cmdshell enabled
    • Edition – Edition, build
    • Collation – Default collation
    • Logins – Present logins with server roles involved
  • Databases
    • Size – Size of database files, space available
    • File configuration – Location of files. Different drives for data and log?
    • Growth configuration – Growth settings for data and log files.
    • Collation – Collation of the database. Is it different from the default server collation?
    • Users – Created users and their database roles.
  • SQL Agent
    • Jobs – The job and job steps.
    • Schedules – Schedules for jobs, next run date and time.

Tags
#Agile #Docs #Powershell #SQL
Question
What to document for SQL SRV ?
Answer
?

Tags
#Agile #Docs #Powershell #SQL
Question
What to document for SQL SRV ?
Answer

At a minimum, I’d say you need to document the following for every server:

  • Machine information
    • Memory – Total memory, available memory.
    • CPU – Amount of CPUs, amount of cores, architecture
    • OS – Architecture, version, service pack, build
    • Disks – Disk, name, size, free space
  • SQL Server engine
    • Configuration – Min and max memory, clr enabled, xp_cmdshell enabled
    • Edition – Edition, build
    • Collation – Default collation
    • Logins – Present logins with server roles involved
  • Databases
    • Size – Size of database files, space available
    • File configuration – Location of files. Different drives for data and log?
    • Growth configuration – Growth settings for data and log files.
    • Collation – Collation of the database. Is it different from the default server collation?
    • Users – Created users and their database roles.
  • SQL Agent
    • Jobs – The job and job steps.
    • Schedules – Schedules for jobs, next run date and time.
If you want to change selection, open document below and click on "Move attachment"

Documenting SQL Server with PowerShell - Simple Talk
first question you ask in response to a performance issue is often “what changed?” It’s much harder to troubleshoot a performance issue without any server documentation. What Needs Documenting? <span>At a minimum, I’d say you need to document the following for every server: Machine information Memory – Total memory, available memory. CPU – Amount of CPUs, amount of cores, architecture OS – Architecture, version, service pack, build Disks – Disk, name, size, free space SQL Server engine Configuration – Min and max memory, clr enabled, xp_cmdshell enabled Edition – Edition, build Collation – Default collation Logins – Present logins with server roles involved Databases Size – Size of database files, space available File configuration – Location of files. Different drives for data and log? Growth configuration – Growth settings for data and log files. Collation – Collation of the database. Is it different from the default server collation? Users – Created users and their database roles. SQL Agent Jobs – The job and job steps. Schedules – Schedules for jobs, next run date and time. Of course, you might need more information depending on your own environment like clustering, replication or mirroring. PowerShell can retrieve all of this information and a lot more, u

Summary

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.