Free for PREMIUM members
Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.
/****** Object: StoredProcedure [dbo].[Erlang_C2] Script Date: 11/09/2010 09:17:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- Author: OKACS
-- Create date: 11/9/2010
-- Description: Finds the # agents necessary to reach a given service level
-- Loop Through Andy's Erlang C proc until the value meets the goal
-- and then display the resulting N
ALTER PROCEDURE [dbo].[Erlang_C2]
@A float, -- Amount of traffic expressed in Erlangs (call arrival rate/sec X average call time)
@P float -- Service Level Goal (Change of call going to hold)
DECLARE @S float -- Resultant Service Level
DECLARE @I int -- Number agents required
SET @S = 99
SET @I = 1
IF (@P < 1 or @P > 99)
-- Error, ServiceLevel Goal cant be less than 1% or greater than 99%
SET @I = 0
-- SELECT 'Looking for goal : ' + cast(@P as varchar)
WHILE ((@S >= 100-@P) and (@I < 35)) -- To a max of 35 so the function does not run forever
EXEC @S = [Erlang_C] @A, @I
SET @I = @I + 1;
-- SELECT 'TRYING ' + cast(@I as varchar) + ' agents for SL of '
-- SELECT @S as SL
SELECT @I as AgentsNeeded
-- Erlangs ServiceLevel
-- EXEC [Erlang_C2] 23.31, 99
Open in new window
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!