How to load the data into new table by getting sql server cpu utilization result data?

Manojkumar D 1 Reputation point
2021-11-09T07:14:59.237+00:00

Hi, could somebody help me to solve, How to load the following data, which got from cpu utilization sql query into new table.

Thanks in advance!

147625-cpu.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,680 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viorel 112.1K Reputation points
    2022-01-14T19:51:16.527+00:00

    To create a new table: 

    SELECT TOP(@lastNmin)
   SQLProcessUtilization AS [SQLServer_CPU_Utilization],
   . . .
into MyNewTable
FROM (SELECT record.value . . .

    Use the #MyNewTable name to create a temporary table.

    If the table already exists: 

    insert MyTable
SELECT TOP(@lastNmin)
   SQLProcessUtilization AS [SQLServer_CPU_Utilization],
. . .
    0 comments