SQL Server Environment Audit

• Jim Guffey

  SSC Rookie

  Points: 42

  More actions

  October 16, 2004 at 3:20 pm

  #84474

  Hi All,

  I think I've seen this here before, but lost the link.... Going into a new environment, what would you look for, how would you audit a new client.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737424

  More actions

  October 18, 2004 at 7:15 am

  #527020

  Scan for all servers.

  Check versions/patches

  Check security config

  Check service accounts

  Check for pwds on all accounts

  Check for use of roles

  Check who has any fixed roles

• Ben Blum

  Right there with Babe

  Points: 776

  More actions

  October 18, 2004 at 8:06 am

  #527045

  This is my favorite article on Auditing new environments, it's really a must read for any SQL Server DBA.

  http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/

   

  Enjoy!