Memory Manager - Target Server Memory (KB) Counter
Posted by: SQL Server 2005 Distilled,
on 29 Nov 2005 |
View original | Bookmarked: 0 time(s)
While writing a code that works with both SQL Server 2000 and 2005, I noticed that for SQL Server 2000 the counter is Target Server Memory(KB) - while the counter for 2005 is Target Server Memory (KB)! See the difference I have SQL Server 2000 SP3a and 2005 RTM. Time to check couple of other SQL 2000 machines - especially one with SP4 and see if the counter is infact called Target Server Memory(KB) (with no space character before the parantheses)....