I’m having the opportunity to test the SeeShell , a tool from Code Owls LLC (read Jim Christopher (@beefarino), created. I can say that so far I’m impressed. I will do some posts but for now I want to show a bit about the power of this tool (guys,you did not see the real-time display counters. it is AMAZING !!! I will show that in our PASS VC PowerShell meeting tomorrow )
I have a module to gathering the performance counters,it is easy to use and scale to n servers , in asynchronous mode using background jobs, with a command line .
In this module I have the option to store into a SQL Server table :
You can see that just for some test, I am using the counters Buffer Cache Hit Ratio and % Processor Time.
Obvious that is not the case in here, but we know that on SQL Server mostly counters cannot be checked alone. So let´s say, just for test, that I need to check out this 2 counters, in a graphical mode.
First I need to aggregate my data by date :
Then with a command line I can See..Shell
Or If I want just the CPU History :
What AWESOMESAUCE tool !!!! (that is a bit that we can do with SeeShell)
As Jim says….SeeShell….Show, Don’t Tell