Home Forums SQL Server 2005 Administering Why both "Target Server Memory" & "Total Server Memory" 0 ? RE: Why both "Target Server Memory" & "Total Server Memory" 0 ?

  • July 4, 2008 at 12:34 am

    #838227

    Yes, all memory related counters are zero :

    "Time", "Available KBytes", "Connection Memory (KB)", "Granted Workspace Memory (KB)", "Optimizer Memory (KB)", "Target Server Memory (KB)", "Total Server Memory (KB)"

    "07/04/2008 13:37:20.605","9043136","0","0","0","0","0"

    "07/04/2008 13:37:35.605","9045300","0","0","0","0","0"

    "07/04/2008 13:37:50.605","9045432","0","0","0","0","0"

    "07/04/2008 13:38:05.605","9045728","0","0","0","0","0"

    "07/04/2008 13:38:20.605","9045652","0","0","0","0","0"

    "07/04/2008 13:38:35.605","9045628","0","0","0","0","0"

    "07/04/2008 13:38:50.605","9045628","0","0","0","0","0"

    "07/04/2008 13:39:05.605","9044676","0","0","0","0","0"

    "07/04/2008 13:39:20.605","9044736","0","0","0","0","0"