You’re offline. This is a read only version of the page.
6,534
To improve the application performance in general please do the following things:-
1. Run the Maintenance plans in SQL server regularly which includes the following tasks:-
a.) Database Integrity check
b.) Close Inactive Sessions
c.) History cleanup
d.) Notify operator about the task success/failure
e.) Update Statistics
f.) Execute T-sql statement to check pending jobs
g.) Backup databases
h.) Analyze database growth percentage
i.) SQL server memory utilization
j.) Evaluate SQL Server Disk Activity
k.) Track the database page performances
l.) Shrinking database log file alone not the data file.
m.) Performing Index defragmentation, Missing Indexes and Unused indexes
n.) Rebuild/Reorganize Index
o.) Configuring SQL database auto growth and auto shrink
2. To Clear application cache files periodically
3. Setting SQL Max Degree parallelism with proper values
4. Disable the hyper threading in the BIOS settings
5. Build network load balancing and clustering
6. Processing the application automatic shutdown, when it’s idle for some* minutes
7. Tracking the server memory utilization
8. Run the Batch process at off-time
9. Disabling debugging action in production server
10.Update the Application version regularly
11. Checking the counter performances
12. Regular maintenance on Disk Defragmentation and Disk Cleanup activities
13. Setting of threshold for disk usage, Memory usage and trigger alerts
14. Clearing the old registry,dump memories and monitoring the event viewer for errors and warnings regularly
Please if any other steps are there to improve the application performance still more kindly help me
*This post is locked for comments
Hi ,
Dynamics Perf tool is really good tool to work with on performance improvement issues.
Please refer the below link:-
blogs.msdn.com/.../setting-up-performance-analyzer-for-microsoft-dynamics.aspx
Hi ,
Please do the below settings also to improve the overall performance:-
In the Performance Option keep Adjust for best performance
In Processor Scheduling select the Background services
To clear the application temp and cache files periodically
Regularly run the windows update and framework updates
Please refer the below link to troubleshoot the performance issue:-
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
