Which performance object should you use?

You manage an instance of SQL Server 2008 named SQL1 . You install an Online Transaction Processing(OLTP) database application on SQL1 .
You want to monitor how server performance is affected by a large number of users connecting anddisconnecting from SQL1.
You want to identify the number of users connecting and disconnecting per secondfrom SQL1. Which performance object should you use?

You manage an instance of SQL Server 2008 named SQL1 . You install an Online Transaction Processing(OLTP) database application on SQL1 .
You want to monitor how server performance is affected by a large number of users connecting anddisconnecting from SQL1.
You want to identify the number of users connecting and disconnecting per secondfrom SQL1. Which performance object should you use?

A.
SQLServer:General Statistics

B.
SQLServer:Exec Statistics

C.
SQLServer:SQL Statistics

D.
SQLServer:Wait Statistics

Explanation:

You should use the
SQLServer:General Statistics
performance object. The
SQLServer:General Statistics
performance object provides counters that can be used to monitor general server-wide activity. For example, youcan use this performance object to identify the number of current connections made to an instance of SQL Serverand the number of users connecting and disconnecting per second from an instance of SQL Server. You can also query the
sys.dm_exec_sessions Dynamic Management View (DMV) to identify all active user connections. You should not use the SQLServer:Exec Statistics performance object because this performance object cannotbe used to identify the number of users connecting and disconnecting per second from a SQL Server instance.The SQLServer:Exec Statistics object is a SQL Server performance object that provides counters to monitorvarious execution statistics on a SQL Server instance. You should not use the SQLServer:SQL Statistics performance object because this performance object cannotbe used to identify the number of users connecting and disconnecting per second from a SQL Server instance.The SQLServer:SQL Statistics object provides counters that monitor compilation and the type of requests sentto a SQL Server instance. You should not use the SQLServer:Wait Statistics performance object because this performance object cannotbe used to identify the number of users connecting and disconnecting per second from a SQL Server instance.The SQLServer:Wait Statistics object provides performance counters that report information about wait status.

Objective:
Optimizing SQL Server Performance

Sub-Objective:
Collect performance data by using System Monitor.

References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > MonitoringResource Usage (System Monitor) > Using SQL Server Objects > SQL Server, General Statistics Object MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Performance > Monitoringand Tuning for Performance > Evaluating Performance > Determining User Activity



Leave a Reply 0

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