November 14, 2023 at 10:32 pm
slow inserts are USUALLY caused by either slow network connection between the client machine and the database OR poor indexing strategy on the table OR stored procedure for the insert is too complex.
As for updating stats every hour, I would only do that if this is a short term thing. If it is for long term usage, I would review what is slow. Load up an XE session and do some real-world timing analysis on the SQL queries to determine where the slowness is.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply