• su5y (4/20/2009)


    what do you mean regards to statistics? We are looking at the paging file this morning which is currently on the c drive which may not be big enough - we split across 2 other drives to see if this helps.

    We have rebooted this morning so documenting performance via perfmon and profiler

    the box has max 12gbRAM - we are only using 8gb - put are planning on upgrading to a more powerful box - also need to review the RAID set-up and this may not be correct either.

    the main problem at moment must be around memory/paging

    1) If you have to ask about statistics you probably ought to get a professional consultant onsite to help solve this problem and mentor you on other topics. 🙂 Adding in data frequently (but < 20% of the table row count) can get you very poor query plans because autoupdate stats hasn't fired but needs to to 'take into account' newly added data.

    2) what is your max sql memory setting? I didn't understand your statements about ram. I would like to see something like "our server has 8GB of ram, sql server is limited to 5.5GB ram max"

    3) page fault delta in task manager is a quickie you can check for paging problems

    4) search web for documentation on DBCC memorystatus and see if anything there pops out as problematic

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service