How to import Perfmon logs into a SQL Database to create Excel Pivot Charts
First published on MSDN on Nov 28, 2017 Authored by Edwin HernandezWe came across a scenario where a customer needs to run a Performance Test of an Application but due to security policies, customer is not able to provide Server-Level access to the Servers where the Application is hosted.Lesson Learned #493: Monitoring Application Performance with Server Performance Counters
Today, I worked on a service request where our customer reported several performance issues in their application connecting to Azure SQL Database. After an in-depth analysis, we found that the issue could be related to the server running the application, including resources assigned, network issues, etc.. Aside from other tools offered by Azure, following, I would like to share the lessons learned using logman that is part of performance monitor tool (perfmon).
