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 2:04 am

    #838250

    Yes, you are right, all SQL-related counters are also zero :

    "Time", "Available KBytes", "Full Scans/sec", "Index Searches/sec",

    "Logical Connections", "Logins/sec", "Transactions", "User Connections",

    "Average Latch Wait Time (ms)", "Total Latch Wait Time (ms)",

    "Connection Memory (KB)", "Granted Workspace Memory (KB)",

    "Optimizer Memory (KB)", "Target Server Memory (KB)", "Total Server Memory (KB)"

    "07/04/2008 15:13:53.864","9031184"," "," ","0"," ","0","0"," "," ","0","0","0","0","0"

    "07/04/2008 15:14:08.864","9031692","0","0","0","0","0","0","0","0","0","0","0","0","0"

    "07/04/2008 15:14:23.864","9031736","0","0","0","0","0","0","0","0","0","0","0","0","0"

    "07/04/2008 15:14:38.864","9032092","0","0","0","0","0","0","0","0","0","0","0","0","0"

    "07/04/2008 15:14:53.864","9031608","0","0","0","0","0","0","0","0","0","0","0","0","0"

    "07/04/2008 15:15:08.864","9029080","0","0","0","0","0","0","0","0","0","0","0","0","0"

    "07/04/2008 15:15:23.864","9024852","0","0","0","0","0","0","0","0","0","0","0","0","0"