Purpose of SYSMON/PERFMON utility


Interview questions

SQL Server - purpose of SYSMON/PERFMON utility

Next>>         SQL Server tutorial  

SQL Server - purpose of SYSMON/PERFMON utility - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

What is the purpose of SYSMON/PERFMON utility?

Perfmon is a tool for DBA’s to monitor performance of a server. The Server could be hosting an SQL Server instance, which allows DBAs to gather data from various Perfmon counters to identify the server utilization. These counters are useful to analyze the system performance.

Perfmon is basically a diagnostic tool provided in windows. It enables DBAs to monitor the server during off peak hours and extensive logging to help accumulate information regarding disturbing elements or problems on the server.

SQL Server - purpose of SYSMON/PERFMON utility - May 05, 2009 at 22:00 PM by Rajmeet Ghai

What is the purpose of SYSMON/PERFMON utility?

SYSMON/PERFMON utility provides system resources usage details. They provide informative counters to analyze the system performance.

SQL Server - purpose of SYSMON/PERFMON utility - June 21, 2009 at 09:00 AM by Amit Satpute

  • Perfmon/Sysmon utility is used to collect data on system resources usage by Database Administrators. The tool’s logging function logs details that can be used for further analysis from the trace.
  • In SQL Server Management Studio (SSMS), there is a set of pre-made reports which DBAs can use to gather information. E.g.: CPU, Memory, Disk session, queries.
  • The reports can be viewed in Management Studio’s Summary Page by highlighting a server instance or database in Object Explorer and then opening reports.
  • Join the SSMS with .RDL file after configuring the SQL Server Reporting Services to format the trace as a manageable report.


Also read

What are the guidelines to use bulk copy utility of SQL Server?

Answer - While importing data, the destination table must already exist......

What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?

The WITNESS server is used to enable the mirror server to recognize the necessity of failover..........

Describe in brief system database.

Answer - Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master.....

Explain in brief how SQL server enhances scalability of the database system.

Answer - SQL Server has efficient ways to enhance scalability of the database system......

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring