SQL Server: Insufficient Memory ErrorInsufficient Memory Error BPool: no remappable address found
Problem usaully resolves itself. When this error happens $YourBigApp users experience slow perf problem Sometimes SQL server fails over (this didn't happen today) This issue has been occuring for a while and it's random behavior.
One thing that it definitely isn't is "random", Sparky. The problem will completely disappear the instant you add the minimum spec'ed memory to the machine and move $OurBigApp off the fucking underpowered database server and onto a dual-proc box with more than 500MB of memory just the way we told you to eight fucking months ago.
I don't believe that memory is our problem we face. We need a solution to this error! $YourBigApp is too slow and databse failing over!
File a ticket with Microsoft and tell them they need to make SQL Server run your 380GB production database in under 100MB of memory. With what appears to be a 486 DX/66 processor.
I just dumped a fucking laptop last week which has more power than their rack-mount which is groaning under the strain of a SQL Server and a dozen enterprise apps. That DB server memory problem is clearly being caused by our software.
You know how this one's being closed: Seh. Venn. TEEN.
< The new Star Trek | I think I might be headed towards death. > |