Skip to main content
Solved

smPerformanceinfoSQL file is huge


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?

Best answer by Naveen Boga

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. 

View original
Did this topic help you find an answer to your question?

4 replies

Neil Cantral
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • 60 replies
  • July 29, 2021

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.


  • Author
  • Freshman I
  • 1 reply
  • July 29, 2021

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.


Neil Cantral
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • 60 replies
  • July 29, 2021

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • July 29, 2021

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. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings