Re: High Paging
From: Todd J Heron (todd_heron_no_spam_at_hotmail.com)
Date: 11/23/04
- Next message: Steven L Umbach: "Re: VPN question"
- Previous message: Todd J Heron: "Re: VPN question"
- In reply to: Justin Emlay: "Re: High Paging"
- Next in thread: Justin Emlay: "Re: High Paging"
- Reply: Justin Emlay: "Re: High Paging"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Nov 2004 23:15:30 -0500
System Monitor values to track:
Memory > Available MBytes -> Measures the amount of physical memory
available to run processes on the computer. If this number is a relatively
low number, such as less than 50 MBytes, consider adding more memory.
Memory > Pages/Sec -> Displays the number of times the requested information
was not in disk and had to be retrieved from disk.
Paging File > %Usage -> Indicates how much of the allocated page file is in
use. If this number is consistently high, such as over 50%, you may need to
add more memory. Note that this number could be artificially high if the
paging file was not properly sized (perhaps under-sized). A good value to
set the page file at is 1.5 times the amount of physical memory for both the
minimum and maximum values (to reduce page file fragmentation). 1.5 times
the amount of physical memory is the system default value after installation
of the operating system. If the paging file reaches the maximum size, you
will see a warning and the system may halt. This is a good reason to
monitor the page file and increase the size.
In summary, if it is determined that there is a memory bottleneck, follow
these steps to resolve:
1) Verify that paging file is correctly sized
2) Avoid placing the paging file on the same partition as the system files
3) If the machine has multiple disk channels, create multiple page files
across the disk channels
4) Run less memory-intensive applications
5) Add more physical memory
Note that insufficient physical memory tends to falsely indicate that the
disk subsystem is a bottleneck. However, if you do not have a memory
problem, and you pinpoint the physical disk subsystem as the system
bottleneck, try the following solutions:
1) Use faster disk and controllers
2) Use disk striping to take advantage of multiple I/O channels
3) Balance heavily-used files on multiple I/O channels
4) Add another disk controller for load-balancing
5) Use Disk Defragmenter to consolidate the files on the disk and optimize
disk access.
Source:
Sybex, "Windows Server 2003 Environment", Lisa Donald, Susan London and
James Chellis, Chapter 9.
-- Todd J Heron, MCSE Windows Server 2003/2000/NT "Justin Emlay" <JEmlay@NoSpam.com> wrote in message news:e9XidXP0EHA.1652@TK2MSFTNGP11.phx.gbl... > Installation manuals are no help and I've searched all I can on Google and > SAP. > > What I'm after is help on figuring out paging problems. I'll ignore task > manager for now. What am I looking for in the System Monitor? > > > > "Todd J Heron" <todd_heron_no_spam@hotmail.com> wrote in message > news:ePlDECqzEHA.2624@TK2MSFTNGP11.phx.gbl... >> You've done a lot with this system, upgrading the SQL database and the OS >> and you've given very little information. In short, who can know what >> going on? Open up System Monitor and start doing some performance >> logging. The Task Manager values are going to change dynamically and not >> give you an accurate picture when you try to manually add them up. I >> suggest you read up on the SQL Server 2000 and SAP R/3 installation and >> Help documentation and search google on issues of upgrading from previous >> versions of those softwares, especially to the sections concomitant with >> OS upgrade. >> >> -- >> Todd J Heron, MCSE >> Windows Server 2003/2000/NT >> >> "Justin Emlay" <JEmlay@NoSpam.com> wrote in message >> news:eHlj74ozEHA.1292@TK2MSFTNGP10.phx.gbl... >>> Nope, none. >>> >>> Also I don't understand why in my task manager it says I have 1.2GB of >>> memory free from 3.8GB and when I add all the processes memory usage up >>> I get way over 5GB of memory used. Are they including swap space? >>> >>> >>> "Todd J Heron" <todd_heron_no_spam@hotmail.com> wrote in message >>> news:u1CDc0ozEHA.4004@tk2msftngp13.phx.gbl... >>>> Is there an active virus scan or some sort of system backup running at >>>> the time of high paging? >>>> >>>> -- >>>> Todd J Heron, MCSE >>>> Windows Server 2003/2000/NT >>>> >>>> "Justin Emlay" <JEmlay@NoSpam.com> wrote in message >>>> news:eX%23zgbozEHA.2196@TK2MSFTNGP14.phx.gbl... >>>>> Windows 2003 Server >>>>> >>>>> This server is running SQL 2000 and SAP R/3 >>>>> >>>>> I had no problem when the server was SQL 7 and Windows 2000. However >>>>> after upgrading to SQL 2000 and Windows 2003 the machine has a high >>>>> rate of paging. >>>>> >>>>> This is of course causing SQL to run very slow. I'm not quit sure >>>>> what's going on. The machine has 1GB of free memory yet the processes >>>>> keep paging. The machine has a total of 4GB of memory and just over >>>>> 14GB of virtual. >>>>> >>>>> Can anyone point me in the right direction? >>>>> >>>>> Thanks, >>>>> Justin >>>>> >>>> >>>> >>> >>> >> >> > >
- Next message: Steven L Umbach: "Re: VPN question"
- Previous message: Todd J Heron: "Re: VPN question"
- In reply to: Justin Emlay: "Re: High Paging"
- Next in thread: Justin Emlay: "Re: High Paging"
- Reply: Justin Emlay: "Re: High Paging"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
