|
Last change
on this file since 6712 was
6712,
checked in by ascheibe, 13 years ago
|
|
#1233
- got db scripts up-to-date
- renamed db related stuff back to 3.3
- fixed a bug in the Status page that occured when the db is empty
|
|
File size:
712 bytes
|
| 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.3].[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.
