none
A significant part of sql server process memory has been paged out......

    質問

  • My MSSQL Server has the following problem

     spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): ????, committed (KB): ???????, memory utilization: 50%.

    My OS is Windows 2003 SP1 with 2GB Ram, SQL server is 2005 standard SP1,

    - No min/max memory is set.

    1. Why is this happen ?

    2. will this problem elimilate when I set min/max memory for SQL server? Actually the SQL Server has Total memory nearly equal to Target memory all day long.

    3. what's working set? what's commited(KB) are what are their relationship ?How can I find the among of pages are out? and which other processes request  SQL to page out ?

    Thanks

    2012年3月6日 16:12

回答

すべての返信