SQL Server is designed to release memory back to other applications as needed, but you can easily cap the memory by accessing server properties via SQL Enterprise Manager. I would recommend a minimum of 512MB for light use, scaling up as needed for heavier used servers.
However, the Page Faults you're seeing aren't overly significant. Avg Disk Queue Length is your real problem. 2 or above indicates a problem. I've never seen a system with queue length above 1 not be in trouble. What is your I/O like? What kind of disks are you using? Controller? RAID configuration if used (though I doubt it from your measurement)? Disk fragmentation? Page file size (should be fixed size at 1.5 to 2 times RAM, or on a separate drive with nothing else to avoid fragmentation)? Chances are you're using insufficiently performing disks and/or controller for the load. Darin. ----- Original Message ----- From: "Kevin Rogers" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, June 04, 2006 12:35 AM Subject: Re: [IMail Forum] new server, much slower The Memory: Page Faults/sec also seems to be spiking past 100. I read somewhere that this might be caused by allocating too much memory to an application. Is this true? How would I check to see how much memory has been allocated for SQL Server or Imail or any other application? Kevin Rogers wrote: > The Avg Disk Queue Length regularly goes above 1000, but the Avg Disk > Read Queue Length stays close to 0, as do most other physical disk and > processor performance attributes. Is this the hold up for my server? > What could be causing it? > > Thanks. > > > Darin Cox wrote: >> Performance Monitor >> >> Darin. >> >> >> ----- Original Message ----- From: "Kevin Rogers" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Saturday, June 03, 2006 7:02 PM >> Subject: Re: [IMail Forum] new server, much slower >> >> >> It goes back to 0, then back to 100. How do I check for the avg? >> >> >> >> Darrell ([EMAIL PROTECTED]) wrote: >> >>>> % Processor is almost always very low. >>>> Avg. Disk Queue Length seems to spike to 100 (or more) every few >>>> seconds >>>> % Disk Time also spikes to 100 all the time >>>> >>> Does the disk queue length clear out quickly? Or does it generally >>> stay high until it spikes back to 100? What does it indicate is the >>> average? >>> >>> Darrell >>> ------------------------------------------------------------------------ >>> >>> Check out http://www.invariantsystems.com for utilities for Declude >>> And Imail. IMail/Declude Overflow Queue Monitoring, SURBL/URI >>> integration, MRTG Integration, and Log Parsers. >>> >>> >>> >>> To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >>> List Archive: >>> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >>> Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ >>> >>> >>> >> To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >> List Archive: >> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >> Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ >> >> To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html >> List Archive: >> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ >> Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ >> >> >> > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html > List Archive: > http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ > Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
