Sean --- I'm sorry, I should have stated, the servers have MYSQL 5.x on them, NOT full blown Microsoft SQL. I should have been clearer. It's for a very tiny database and app used by a couple people. Sorry for the typo... big difference between MySQL and SQL I guess, oops!.
Jesse Rink Source One Technology, Inc. HP Partner 262 993 2231 ** Please visit our blog! http://www.sourceonetechnology.com/blog/ ________________________________ From: [email protected] <[email protected]> on behalf of Sean Martin <[email protected]> Sent: Thursday, February 25, 2016 12:10 PM To: [email protected] Subject: Re: [NTSysADM] Memory fun I'm not proficient with SQL by any means, but it may be worth checking how SQL is configured to leverage physical memory. Perhaps it's capped at the amount of physical memory it can use? - Sean On Thu, Feb 25, 2016 at 6:39 AM, Jesse Rink <[email protected]<mailto:[email protected]>> wrote: This might be a fun one to discuss... I'm not even sure this is problematic or no big deal at all. I'm leaning towards no big deal. I bring it up because the behavior is unlike any other server I have (though that doesn't necessarily mean it's wrong/bad). I have a physical server running Windows 2012 R2 with 24GB of physical memory. Paging file is set to be managed by the OS and is currently 4.58GB in size. The server is not heavily used. What's strange is, the server's paging file usage is constantly upwards of 90% -- which is unlike any other servers I manage, including servers that are running on the -same- hardware spec, -same applications-, etc. The server in question with the 90%+ paging file usage is a bit of an anomaly. Few things to note... 1. The server's Committed Bytes is always hovering around 12GB or so... which is way below the Commit Limit (I think is 28GB or so, (physical memory + virtual memory)). So that seems to be completely normal. 2. The server's Page Faults/sec and Pages/sec are nearly identical with other servers I have that are serving up the same roles/functions and with the same hardware specs. So that also seems completely normal. 3. The server's Available Memory is always around 50%. So that also seems to be completely normal. 4. Because of the 90% Paging File Usage, the server's c: drive "Disk Write Time %" is noticeably higher (averaging around 20% utilization) than other servers (which average around 3% utilization), but it's obviously not high enough that it's affecting performance. I'd also expect to see higher Disk Write Time % with a more heavily utilized Page File anyways. 5. The server's Paging File Usage hovers around 90% (a reboot will lower it temporarily but will return back to 90% after 2-3 days) continually. The other servers I have that are serving up the same roles/functions and with the same hardware specs usually show around 0-10% Paging File Usage. Big difference. 6. The paging file itself, seems to be used, as far as process/bytes go, by SQL (there's a very -small- app using SQL on the box) and also by Java. However, nearly identical servers with the same apps (and SQL too) and hardware specs, don't show the same high Paging File Usage results. All in all, there's seemingly nothing wrong, but it bugs me that the Page File Usage on this particular server is so high. It SEEMS like perhaps there's just something wonky with the SQL and/or Java apps on this particular box that are using the Pagefile so much versus numerous other similar servers... I guess I'm curious... Would any else bother spending the time to figure out what's going on with the Pagefile? Ha. Like I said, there's no real performance hits or problems so maybe it'd be a waste of time, except for figuring it out for curiosity's sake. Jesse Rink Source One Technology, Inc. HP Partner 262 993 2231<tel:262%20993%202231> ** Please visit our blog! http://www.sourceonetechnology.com/blog/
