Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

Munis database Database is growing quickly and there is a need to identify what the cause is.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • MunisDatabase
  • SQL Server Management Studio (SSMS)


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

Though causes can vary, exponential growth could be due to a System Log table filling with multiple error/log messages daily.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution
  1. Log into the Munis database server through SSMSExpand
  2. Open SSMS (SQL Server Management Studio)
  3. Connect to the applicable instance
  4. Expand Databases by clicking on the plus symbol (+)
  5. Right-click on Munis database:Ex. mun1234prod
  6. Navigate to Report Reports > Standard Reports > Disk Usage by Top Tables

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

Please create a case with TSM Support for further assistance in the Support Portal.