Back to OIM Explorer

dbo.QBM_FGIServerMemoryUsed

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 959 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL40 lines
1CREATE FUNCTION dbo.QBM_FGIServerMemoryUsed(2) RETURNS int3AS4BEGIN5  DECLARE @erg int6  DECLARE @OSLimit_GB float7  DECLARE @UseLimit_GB float8  DECLARE @CurrentlyUsed_GB float9  SELECT10    TOP 1 @OSLimit_GB = convert(float,11    os.committed_target_kb) / 1024.0 / 1024.012  FROM sys.dm_os_sys_info os13  SELECT @UseLimit_GB = @OSLimit_GB -(14  SELECT15    convert(float, sum(pages_kb)) / 1024.0 / 1024.016  FROM sys.dm_os_memory_clerks c17  WHERE18    c.virtual_memory_reserved_kb > 0)19  SELECT @UseLimit_GB = CASE20  WHEN @OSLimit_GB <= 8.0 THEN21  @UseLimit_GB * 0.7022  WHEN @OSLimit_GB <= 16.0 THEN23  @UseLimit_GB * 0.7524  WHEN @OSLimit_GB <= 32.0 THEN25  @UseLimit_GB * 0.8026  WHEN @OSLimit_GB <= 96.0 THEN27  @UseLimit_GB * 0.8528  ELSE @UseLimit_GB * 0.9029  END30  SELECT31    @CurrentlyUsed_GB = convert(float,32    sum(pages_kb)) / 1024.0 / 1024.033  FROM sys.dm_os_memory_clerks c34  WHERE35    c.virtual_memory_reserved_kb = 036  SELECT37    @erg = convert(int,38    (@CurrentlyUsed_GB / @UseLimit_GB * 100.0))39  RETURN(@erg)40END
Open raw exported source
SQL ยท Raw8 lines
1    create   function dbo.QBM_FGIServerMemoryUsed () returns int  as begin declare @erg int declare @OSLimit_GB float declare @UseLimit_GB float2 declare @CurrentlyUsed_GB float select top 1 @OSLimit_GB = convert(float, os.committed_target_kb) / 1024.0 / 1024.0 from sys.dm_os_sys_info os  select3 @UseLimit_GB = @OSLimit_GB - (SELECT convert(float, sum(pages_kb))/ 1024.0 / 1024.0 FROM sys.dm_os_memory_clerks c where c.virtual_memory_reserved_kb 4> 0 ) select @UseLimit_GB = case when @OSLimit_GB <= 8.0 then @UseLimit_GB * 0.70 when @OSLimit_GB <= 16.0 then @UseLimit_GB * 0.75 when @OSLimit_GB <=5 32.0 then @UseLimit_GB * 0.80 when @OSLimit_GB <= 96.0 then @UseLimit_GB * 0.85 else @UseLimit_GB * 0.90 end  SELECT @CurrentlyUsed_GB = convert(float6, sum(pages_kb))/ 1024.0 / 1024.0 FROM sys.dm_os_memory_clerks c where c.virtual_memory_reserved_kb = 0    select @erg = convert(int, (@CurrentlyUsed_GB7 / @UseLimit_GB * 100.0))  return (@erg) end 8