This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Hi,
When we use performance monitor, what we will check and how to schedule it?
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
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.