Skip to content
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
SQL Server Blog Forum

Guide to SQL Server DBAs and Developers

  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • DBA,  Performance

    Perfmon Data collection – Integrate SSRS with Perfmon – Dashboard performance of database graph using SSRS Collect perfMon and automate it load to SQL database and generate reports

    October 9, 2019

    DBA wants to collect metrics and analysis them and present them to management to get something done by using the data (to check performance issue, benchmark for migration etc) and it is all about data and metric nowadays. How to collect them and show as a presentation. Two parts are there: 1. You can setup only Perfmon, T-SQL and use excel 2. Setup perfmon, T-SQL and configure SSRS. Tools needed: SSRS, Perfmon.msc, Relog.Exe, database engine, PowerShell & CMD. Steps: Create two notepad and save it any drive (performance.lst, server.lst) and one CMD file createlogs.cmd – The performance notepad will have counter details and server notepad will have serve name and…

    Read More
    Muthukkumaran 3 Comments

Search Box

Advertisements

Categories

  • AlwaysON
  • AutoMon
  • Azure
  • Backup/Restore
  • Basics for freshers
  • DBA
  • Docker
  • DR/HA
  • Indexes
  • Internals
  • Junior DBA
  • Microsoft
  • Oracle
  • Performance
  • PowerShell
  • Questions
  • Scripts
  • SQL party
  • T-SQL
  • VLDB

Archives

Top SQL server blogs

  • Adam Machanic
  • Amit Banerjee
  • Brent Ozar
  • Gail Shaw
  • Grant Fritchey
  • Paul White
  • Pinal Dave
  • SimpleTalk
  • Sqlblog
  • SQLskills
Powered by RAR Web Solutions