Hi, I am trying to make a Data Lab Input for Splunk DB Connect using the followng query:
declare @cntr_value_1 numeric(20,3)
declare @cntr_value_2 numeric(20,3)
declare @delay_time varchar(12)
set @delay_time = right(convert(varchar(30),dateadd(second,1,0),121),12)
select @cntr_value_1 = cntr_value
from [master].[dbo].[sysperfinfo]
where counter_name = 'Page reads/sec'
waitfor delay @delay_time
select @cntr_value_2 = cntr_value
from [master].[dbo].[sysperfinfo]
where counter_name = 'Page reads/sec'
SELECT convert(numeric(20,1),round((@cntr_value_2-@cntr_value_1)/1,3)) AS DB_VALUE
The query executes fine, but when I want to save the Input, the following message appears:
There was an error processing your request. It has been logged (ID 13fb315b3ef49ffd).
I wonder if the problem are the variables.
... View more