| Line | |
|---|
| 1 | /****** Script for SelectTopNRows command from SSMS ******/
|
|---|
| 2 | SELECT CONVERT(VARCHAR(10), [DateTime], 104) AS [Day]
|
|---|
| 3 | ,AVG(CAST([Cores] AS FLOAT)) AS Cores
|
|---|
| 4 | ,AVG(CAST([FreeCores] AS FLOAT)) AS FreeCores
|
|---|
| 5 | ,AVG([CpuUtilization]) AS CpuUtilization
|
|---|
| 6 | ,AVG(CAST([Memory] AS FLOAT)) AS Memory
|
|---|
| 7 | ,AVG(CAST([FreeMemory] AS FLOAT)) AS FreeMemory
|
|---|
| 8 | ,MAX([ExecutionTimeHours]) AS [ExecutionTimeHours]
|
|---|
| 9 | ,MAX([ExecutionTimeFinished]) AS [ExecutionTimeFinished]
|
|---|
| 10 | ,MAX([StartToEndTimeFinished]) AS [StartToEndTimeFinished]
|
|---|
| 11 | FROM [HeuristicLab.Hive-3.4].[dbo].[view_Statistics]
|
|---|
| 12 | GROUP BY CONVERT(VARCHAR(10), [DateTime], 104)
|
|---|
| 13 | ORDER BY CONVERT(VARCHAR(10), [DateTime], 104) DESC |
|---|
Note: See
TracBrowser
for help on using the repository browser.
