I'm looking into using Windows Performance Monitor to analyse server performance. I'm testing on the adventure works 2014 database on SQL Server 2014.
I want to try to Max out the CPU, Memory, disk usage (I/O) and possibly put a high amount of User activity. Then I can train myself in using windows performance monitor to take logs for performances around this area.
I know for CPU I can just run a heavy query within a while loop (maybe infinite) and that will go towards maxing it out.
I'm less sure about the other ones. I've tried queries which select from large tables (30,000 records), and are in a while loop to try and use some of the memory up. But it doesn't seem to drop the Available Mbytes left counter on performance monitor. Is this because the tables not big enough?
As for the disk usage, I imagine I may have to do some updates or inserts so that the disk is being written to. But I can't seem to get it to effect disk usage.
As for network, I can only think of opening up multiple queries and running them concurrently, but that seems a bit messy.
As a side note, I want to script it all myself. Rather than using any extra tools or pre canned apps that do it for you.