Shrink WSS_Login_Database in Share Point

• By defaults WSS_Logging  keeps 14 days information that result in a big database. 3 days information is sufficient for most test.
• Check below result from Sql Management studio and size of database
  
• To change in log configuration you need to open Share point management shell As a Administrator.
• Below command is use to find the current configuration of log in Share Point
  

  PS C:\Users\dynamicsax.admin> Get-SPUsageDefinition
• Run below command to change log days from 14 to 3
  PS C:\Users\dynamicsax.admin> Get-SPUsageDefinition  | ForEach-Object { Set-SPUs
  ageDefinition $_ -DaysRetained 3}
• Then check again using above given command you will get below output.
•