The Default Windows Power Plan seems to be causing me some headaches on some busy SQL engines. Ok so if I had it my way I would have the DBA IO Tools, setup to update and use. That is some amazaing work ! But I belive this would have to pass throuh security at the company I work at. SO what to do, I checked Chrissy LemMaire's site, looked pretty doable. The PS Code will build you a nice csv for quickly importing into a SQL table. I hope you may be able to make use of the code.
Collect Data from Multiple Instances Using SSIS and Powershell
Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.
2015-02-23
8,295 reads