Performance monitor

Question

Hi,

When we use performance monitor, what we will check and how to schedule it?

Answer 1

Read this article exactly what you want.

http://technet.microsoft.com/en-us/library/dd744567(v=ws.10).aspx

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Hi Surya,

In general, we can monitor SQL Server or Windows operating system to investigate performance related issues in many factors, such as:

1.Disk activity
2.Processor utilization
3.Memory usage

Could you tell me that which counter you want to monitor?
Here I provide an example, we can schedule a job to collect SQL Server performance monitor counters, please refer to this link:
http://databasebestpractices.com/schedule-job-collect-sql-server-performance-monitor-perfmon-counters/

This is a link about SQL Server counters:
http://technet.microsoft.com/en-us/library/ms137622.aspx

Regards,
Heidi Duan