Which performance object should you use?

You administer a SQL Server 2008 instance. Users report that applications that run on the
server perform poorly. You suspect that the performance issues are related to table scans.
You need to use an appropriate Windows System Monitor object to capture the appropriate
information.
Which performance object should you use?

You administer a SQL Server 2008 instance. Users report that applications that run on the
server perform poorly. You suspect that the performance issues are related to table scans.
You need to use an appropriate Windows System Monitor object to capture the appropriate
information.
Which performance object should you use?

A.
SQLServer:Databases

B.
SQLServer:Access Methods

C.
SQLServer:Buffer Manager

D.
SQLServer:Memory Manager



Leave a Reply 0

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