Hello, I have the following problem:
"A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 92984, committed (KB): 1688060, memory utilization: 5%."
I get this error every two-three minutes aproximatly, since 10 days ago. My server has the following caracteristics:
Windows server 2003 Standar Edition SP2 (32bits)
intel(R) Xeon(TM) CPU 3.6GHz and 3.5GB de RAM.
SQL Server 2005 Standar Edition 9.00.3068.00 SP2 (32bits).
SQL Server hasn´t allocated MIN nor MAX memory.
I enclose two files with performance and administration task.
I check the counter 'SQL Server Buffer: Buffer Cache Hit Ratio' for half an hour and the average value
is 99% aproximatly.
Now, my sql server doesn´t response, it´s very very very slow.
How can I solve this problem??, which causes are??. It`s emergency. I need help.
What changed 10 days ago? Answer that and you'll have the solution to your problem. Do you have a "runaway" query running? Did someone install some new software or hardware on the server? Did someone promote some code or a change to the code?
If it hasn't been overwritten yet, check the default trace file... IIRC, it's in the same directory as the SQL Server log files which you might also want to check. Also, check the Windows Server error logs...
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs