Viewing 6 posts - 1 through 6 (of 6 total)
Yes a machine is viewReportMonitorCounterLog.ComputerName.
The avg needs to be calculated per counter instance per machine - ie avg of c drive values for machine 1, avg of c drive values...
April 8, 2014 at 3:22 am
Where would the Group By statement go?
April 8, 2014 at 2:22 am
I have got:
SELECT
viewReportMonitorCounterLog.agentGuid
,viewReportMonitorCounterLog.ComputerName
,viewReportMonitorCounterLog.GroupName
,viewReportMonitorCounterLog.[Counter Object]
,viewReportMonitorCounterLog.Counter
,viewReportMonitorCounterLog.[Counter Instance]
,"Critical Utilisation" = CASE
WHEN...
April 8, 2014 at 12:59 am
When I've run sp_who2, there is nothing running with the programname "SQL Server Profiler", but I have found that there are entries with SQL Trace. These seem to be coming...
July 28, 2013 at 5:51 pm
I had re-run the first query after I the one to stop the trace and so it restarted as trace id 1. It was originally trace id 2.
When I run...
July 25, 2013 at 4:25 pm
Viewing 6 posts - 1 through 6 (of 6 total)