11.0

© 2014 ABBYY Production LLC. All rights reserved.
73
You can also use the counter SQLServer: Databases: Transaction/Sec: _Total to measure the total activi-
ty of SQL Server. However, it measures only the activity within the transaction, not the whole activity, which
can lead to erroneous results.
You can also use the following counters to analyze the amount of memory consumed by the server and estimate
whether the server has enough memory:
2. SQLServer: Memory Manager — Target Server Memory (KB) shows how much memory is required for
SQL Server. If the value of this parameter matches the value of SQLServer: Memory Manager — Total
Server Memory (KB), it means that SQL Server has enough memory.
3. SQLServer: Memory Manager — Total Server Memory (KB) shows how much memory SQL Server actu-
ally uses. If the value of this parameter matches the value of SQLServer: Memory Manager — Target
Server Memory (KB), it means that SQL Server has enough memory. However, if the value of this counter is
smaller, it means that more available memory is needed to optimize performance of SQL Server.