In my last SQL Server 2012 administration seminar, I used Performance Monitor to analyse and troubleshoot issues regarding SQL Server. It is built into Windows and many administrators used it a lot in the old days when some of the tools we have now in our disposal did not exist. So this is a free tool that you do not need to download. Performance Monitor or PerfMon for short, can be used to monitor performance real-time, capture various metrics and you can select what you want to monitor and for how long.You can capture information about the hardware, the operating system, SQL Server and more.So it is not a tool for troubleshooting SQL Server only. The whole process is automated and so is the data collection. With PerfMon we can track nearly every type of system performance Disk Memory Cpu network The overhead of using PerfMon is minimal in most cases but you should be careful when selecting the sampling interval. One good advice is not to use too many counters and not sampling intervals less than one second.


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

Sql Server,Sql Server 2005,SQL Server 2008,SQL Server 2012,perfmon,performance monitor