Greetings,
I see a lot of query’s on our MSQL that take above 1 second to execute.
All of them looks like the one below, except that the values are different of course.
Can someone tell me what is going on?
declare @p1 int
set @p1=3636000
exec sp_prepexec @p1 output,N'@P0 int,@P1 int,@P2 bigint',N'SELECT TOP 1 "tagid","intvalue","floatvalue","stringvalue","datevalue","t_stamp","dataintegrity" FROM sqlt_data_1_2014_10 WHERE "tagid" IN (@P0,@P1) and "t_stamp"<@P2 ORDER BY "t_stamp" DESC ',296,9,1414595397310
select @p