Your company has a server named SQL1 that runs SQL Server 2005 Enterprise Edition. SQL1
has 2 GB of RAM, 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month.
Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log?
A.
MSAS200S:Cache
B.
MSAS 2005:Memory
C.
MSAS 2005:Proactive Caching
D.
SQLServer:Buffer Manager
E.
SQLServer:SQL Statistics
F.
SQLServer:General Statistics