EXEMPLO_1212310
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
RMMedidor
Parameters
Name
Type
Mode
Definition
/* STORE PROCEDURE DE MEDICAO E USO DO SERVIDOR */ create procedure RMMedidor as declare @cpu_busy float declare @io_busy float declare @idle float set nocount on select @cpu_busy = @@cpu_busy, @io_busy = @@io_busy, @idle = @@idle waitfor delay '00:00:01' select @cpu_busy = @@cpu_busy - @cpu_busy, @io_busy = @@io_busy - @io_busy, @idle = @@idle - @idle select porcentagem = convert(numeric(10,0),(@cpu_busy+@io_busy)/(@cpu_busy+@io_busy+@idle)*100) return (0)