April 9, 2008 at 12:43 pm
Hello,
I have this SQL 2005 server, it is running CRM application, the server has 3 GB of RAM, It gives the below error, can I get any suggestions to fine tune my SQL 2005
4030: Excessive paging has been detected on server ISLCRM. The pages per second reading is currently 1094.21
Thanks,
Dev
April 10, 2008 at 12:43 am
Hi
Seems like SQL Server is facing memory restrictions. Some points that i can think of...
Is your database very large and are you working with large datasets. Do you have a lot of temp table/table datatype usage.
Have you set any memory usage restrictions in your SQL server configuration.
Do you have any other memory intensive applications running in your db server.
"Keep Trying"
April 11, 2008 at 2:56 am
Windows want to use more memory than it has available.
As Chirag says, check what is happening in SQL Server. SQL should adjust its memory use to avoid excessive paging, but if the min memory value is set too high, this can sometimes be a problem. Personally, I now prefer to leave min memory at zero, as this lets the system degrade more gracefully if memory is over committed.
You also need to look at what is happening outside of SQL Server. Are you running IIS or SQLAS or SQLRS on the same box, all of these like lots of memory and it can be difficult to run all of them efficiently on a single 32-bit server.
Are you copying large files (multi-GB) from the server to elsewhere on the network - this can cause Windows to steal memory from other processes for the file cache while the copy is in progress.
All of these are just a few of the things you need to check. Keep looking until you understand what processes are using memory and how you can balance memory requirements with what is available.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply