Retreive Logs from SQL Server

Jul 1, 2013 at 4:20 PM

Is it possible in any way to specify connection string and load Counter Logs directly from the SQL Server Database?

Currently, we can only specify and load Log files on the Counter Log tab. It would be really handy feature if we could also specify connection string to the SQL Server and then retrieve logs out of that database.

Jul 10, 2013 at 5:46 AM
I started work on counter logs in SQL databases, but I haven't worked on it in a long time. I've been primarily occupied with writting the Windows Performance Analysis Field Guide book as a companion to the PAL tool.

Take a look at PAL.ps1 and you should see some of the work I've made towards it. It certainly isn't ready though.
Jul 17, 2013 at 5:38 PM

I'm hijacking this thread to ask about the book. It sounds great! Any thoughts on when it would be available? Do you need any proofreaders? :)

Jul 31, 2013 at 6:32 AM
Hi sfslug,

Thanks for asking about the book. The book is coming along nicely. It's called the "Microsoft Windows Performance Analysis Field Guide: A practical approach to Windows 8 and Windows Server 2012". It is due to hit the market early next year. I'm writing it for all of my friends who need guidance on why their computer or their enterprise solution is slow.

Thank you for the offer, but I'm keeping the list of technical reviewers down to a handful of people. Are you an expert in an area of Windows performance analysis?
Aug 19, 2014 at 5:39 PM
I'd like to retrieve/analyse logs from SQL Server, as well....
Sep 8, 2014 at 11:38 PM
I've considered adding support for counter log written to SQL Server. It is on my to do list, but as a low priority. My first priority is getting the memory and CPU usage of multi-threading in the PAL tool more stable and efficient.