SQL Server SQL语句索引监控
use profiler to capture a server status for 24 hrs, the result stored into table Conn_AdminIII_2009_02_10
0. create index
ref: Covert datetime to nvarchar:
Create index idx_starttime on Conn_AdminIII_2009_02_10(starttime)1.SQL query:
select * from Conn_AdminIII_2009_02_10 where starttime between '2009-02-20 00:00:05.680' and '2009-02-20 09:10:05.680' order by duration desc2.exec sp_executesql @sql:
declare @starttime datetime
declare @endtime datetime
set @starttime = '2009-02-20 00:00:05.680'
set @endtime = '2009-02-20 09:10:05.680'
declare @sql nvarchar(max)
set @sql= N'
select * from Conn_AdminIII_2009_02_10 where starttime
between '''+ convert(nvarchar(200), @starttime, 120) +'''
and '''+ convert(nvarchar(200), @endtime, 120) +'''
order by duration desc'
exec sp_executesql @sql
select convert(nvarchar, getdate(), 120)
declare @starttime datetime
set @starttime = '2009-02-20 08:00:05.680'
select convert(nvarchar, @starttime, 120)
作者:Buro#79xxd
出处:http://www.cnblogs.com/buro79xxd/
文章版权归本人所有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。