search

spaghettidba / WorkloadTools

A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud
MIT License
232 stars 52 forks source link

Export WorkloadViewer as a "Report" #99

Closed SQLGeordie closed 3 years ago

SQLGeordie commented 3 years ago

I would like to be able to output the information seen in WorkloadViewer as some kind of report, this way it could be incorporated into a documentation for a migration project and/or be able to provide the information to the relevant people (ie. management) involved without having to have the tool themselves..

spaghettidba commented 3 years ago

There is PowerBI for that: open the "reports" folder under the workloadtools installation folder. Double click the file "WorkloadTools Report - Template.pbit" and it will prompt for connection details. Fill in the info and proceed and it will load all the data in the pbix file, no need to have the database around :)