Problem I’ve noticed on demo machines that sometimes Telegraf doesn’t start on the first try, and this seems to not happen on most of my production servers, but they have a lot more memory and CPU power. So I figured I would write a quick blog post and provide a
Problem We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and display that information in a way our DBAs can read it. Also, we would like to keep the cost down. I know this blog looks really long and may
Must say I’m loving SQL Operations Studio. I’m lucky enough to have some systems with 2017 already installed on them with Query Store enabled so that gives me the ability to track wait stats over a period of time inside a database. For those that are new to 2017, Query Store
In this part of the process, we will set up a process to automatically stop the data collector or counter log on the remote server. Then rename the file with a time stamp if it is an older version of Windows. Finally, we will start the data collector or counter