Solved

smPerformanceinfoSQL file is huge

  • 29 July 2021
  • 4 replies
  • 253 views

This file, and it’s related indexes are taking up half of our database. The current file size of the database (.mdf file) is 135GB and we’ve only had it installed for three weeks.

At this rate we will have a 1TB db in ten months.

 

Any idea what’s going on with this?

icon

Best answer by Naveen Boga 29 July 2021, 21:42

View original

4 replies

Userlevel 7
Badge +17

Yes, SMperformanceinfosql this table is related to Performance Monitor Logs.

 

–  This table save trace of requests, sql querries, memory usage. This can be helpful for Acumatica support and performance issue investigation, but after that you can clear it. 

Userlevel 5
Badge +3

I believe that table is populated by the Request Profiler. Using the ‘Clear Log’ action should clear that table out.

Sorry, SMperformanceinfosql in the title is the name of the table.

And I ran a sql script to find that the indexes are as big a part of the problem.

Userlevel 5
Badge +3

A good place to start would be the Space Usage screen under System Maintenance. This can help narrow it down to specific tables or snapshots. Uploaded files can get out of hand too if you are not using external file storage options.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved