34,838
社区成员




declare @DataSizeValue varchar(100)
set @strSQL='select top 1 @DataSizeValue=Sum(CounterValue) from (
select CounterValue from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterDateTime > (select dateadd(ss,-5,(select MAX(CounterDateTime)
from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterID in ('6252')))) and CounterID in ('6252')
and InstanceName like ''%''(select top 1 InstanceName from #ASB_SaveInstanceInfo where ID='+cast(@j as varchar)+' )''%''
and InstanceName like ''%''(select top 1 DBName from #ASB_SaveInstanceInfo where ID='+cast(@j as varchar)+' )''%'' ) T
'
EXEC sp_executesql @strSQL, N'@DataSizeValue varchar(100) output',@DataSizeValue OUTPUT
select @DataSizeValue=Sum(CounterValue) from (
select CounterValue from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterDateTime > (select dateadd(ss,-5,(select MAX(CounterDateTime)
from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterID in ('6255')))) and CounterID in ('6255')
and InstanceName like '%'(select top 1 InstanceName from #ASB_SaveInstanceInfo where ID=1 )'%'
and InstanceName like '%'(select top 1 DBName from #ASB_SaveInstanceInfo where ID=1 )'%' ) T
declare @DataSizeValue nvarchar(4000)
set @strSQL=N'DECLARE @InstanceName NVARCHAR(1000),@DBName NVARCHAR(1000);
select top 1 @InstanceName=InstanceName from #ASB_SaveInstanceInfo where ID='+cast(@j as varchar)+';
select top 1 @DBName=DBName from #ASB_SaveInstanceInfo where ID='+cast(@j as varchar)+';
select @DataSizeValue=SUM(CounterValue)
FROM dbo.ASBSQL_PerformanceCounterDetailM7
where CounterDateTime > (select dateadd(ss,-5,(select MAX(CounterDateTime)
from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterID in (''6252'')))) and CounterID in (''6252'')
and InstanceName like ''%''+@InstanceName+''%''
and InstanceName like ''%''+@DBName+''%'''
EXEC sp_executesql @strSQL, N'@DataSizeValue varchar(100) output',@DataSizeValue OUTPUT
declare @DataSizeValue nvarchar(4000)
set @strSQL=N'select top 1 @DataSizeValue=Sum(CounterValue) from (
select CounterValue from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterDateTime > (select dateadd(ss,-5,(select MAX(CounterDateTime)
from dbo.ASBSQL_PerformanceCounterDetailM7
where CounterID in (''6252'')))) and CounterID in (''6252'')
and InstanceName like ''%''(select top 1 InstanceName from #ASB_SaveInstanceInfo where ID='+cast(@j as varchar)+' )''%''
and InstanceName like ''%''(select top 1 DBName from #ASB_SaveInstanceInfo where ID='+cast(@j as varchar)+' )''%'' ) T
'
EXEC sp_executesql @strSQL, N'@DataSizeValue varchar(100) output',@DataSizeValue OUTPUT