Which performance object should you add to the counter log?

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?

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.
MSAS 2005:Cache

B.
MSAS 2005:Memory

C.
MSAS 2005:Proactive Caching

D.
SQLServer:Buffer Manager

E.
SQLServer:SQL Statistics

F.
SQLServer:General Statistics



Leave a Reply 0

Your email address will not be published. Required fields are marked *