Post reply

Page Faults/sec high and performance degraded !

  • December 15, 2003 at 11:40 am

    #486230

    quote:

    We are currently building a new database server with increased memory, processing power and server 2003, but I'm wondering whether capping the memory available to SQL Server would help to give the DTSRUN application additional memory to work with ?

    We had to do this with one particular DB server that had an application running on it (only vendor supported config) and got decent results with it. It keeps the memory battle from taking place.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • December 17, 2003 at 2:50 am

    #486593

    Many thanks.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply