最近系统使用有卡顿现象，数据库使用的是SQL 2005，用Profiler跟踪发现半小时左右为出现以下脚本记录，application name 为SC_MSSQL .
不知道是不是数据库出什么问题了？请大神们看看
Select [db_id] , obj.[schema_id] , obj.[object_id] ,
CASE WHEN CONVERT ( NVARCHAR(2) , [type] ) In ( N'U' , N'S' )
THEN N'L'
WHEN CONVERT ( NVARCHAR(2) , [type] ) = N'V'
THEN N'B'
ELSE N'E'
END As [QSItype] ,
CONVERT ( NVARCHAR(2) , [type] ) As [type] , [db_name] , [schema_name] , [obj_name] ,
IsNull ( IsNull ( def.[number] , nodef.[number] ) , 0 ) As number ,
IsNull ( IsNull ( def.[colid] , nodef.[colid] ) , 1 ) As colid ,
IsNull ( IsNull ( def.[definition] , nodef.[definition] ) , [schema_name] + N'.' + [obj_name] ) As definition
From ( Select 8 As [db_id] , [schema_id] , [object_id] , [type] ,
N'THIS4_YB2' COLLATE Chinese_PRC_BIN As [db_name] ,
IsNull ( SCHEMA_NAME ( [schema_id] ) , N'dbo' ) COLLATE Chinese_PRC_BIN
As schema_name ,
LTRIM ( RTRIM ( [name] ) ) COLLATE Chinese_PRC_BIN As obj_name
From [THIS4_YB2].[sys].[all_objects] WITH ( NOLOCK )
Where ( [is_ms_shipped] = 0
Or [object_id] >= 0 )
And CONVERT ( NVARCHAR(2) , [type] ) Not In ( N'C' , N'D' , N'F' , N'PK' , N'R' , N'SN' , N'SQ' , N'UQ' , N'IT' )
And [name] Not Like N'#%' ) As obj
LEFT JOIN
( Select [schema_id] , objs.[object_id] , 1 As "number" , 1 As "colid" ,
definition COLLATE Chinese_PRC_BIN As definition
From [THIS4_YB2].[sys].[all_sql_modules] As cmts WITH ( NOLOCK ) RIGHT JOIN [THIS4_YB2].[sys].[all_objects] As objs WITH ( NOLOCK )
ON cmts.[object_id] = objs.[object_id]
JOIN [master].[dbo].[spt_values] As vals ( NOLOCK )
ON CONVERT ( NVARCHAR(2) , objs.[type] ) = SUBSTRING ( vals.[name] , 1 , 2 ) COLLATE Chinese_PRC_BIN
And vals.[type] = N'O9T'
Where [is_ms_shipped] = 0
And CONVERT ( NVARCHAR(2) , objs.[type] ) Not In ( N'C' , N'D' , N'X' , N'PC' , N'IT' , N'U' , N'V' , N'F' , N'K' , N'L' , N'R' , N'SN' ) ) As def
ON obj.[schema_id] = def.[schema_id]
And obj.[object_id] = def.[object_id]
LEFT JOIN
( Select [schema_id] , objs.[object_id] , 1 As "number" , 1 As "colid" ,
CASE WHEN CONVERT ( NVARCHAR(2) , objs.[type] ) In ( N'U' , N'S' , N'V' )
THEN NULL
ELSE N'~QSISCEN~CREATE ' + CASE WHEN CONVERT ( NVARCHAR(2) , objs.[type] ) In ( N'P' , N'X' , N'PC' )
THEN N'PROCEDURE '
WHEN CONVERT ( NVARCHAR(2) , objs.[type] ) In ( N'TR' , N'TA' )
THEN N'TRIGGER '
WHEN CONVERT ( NVARCHAR(2) , objs.[type] ) = N'V'
THEN N'VIEW '
WHEN CONVERT ( NVARCHAR(2) , objs.[type] ) Like N'%F%'
THEN N'FUNCTION '
ELSE N'OTHER'
END + IsNull ( SCHEMA_NAME ( [schema_id] ) , N'dbo' ) + N'.' + LTRIM ( RTRIM ( objs.[name] ) ) +
N' AS ' + NCHAR(13) + NCHAR(10) + NCHAR(9) + N'BEGIN' + NCHAR(13) + NCHAR(10) + NCHAR(9) + NCHAR(9) +
N'--definition for ' + IsNull ( SCHEMA_NAME ( [schema_id] ) , N'dbo' ) + N'.' +
LTRIM ( RTRIM ( objs.[name] ) ) + N' of type ' +
LTRIM ( RTRIM ( SUBSTRING ( vals.[name] , 5 , LEN ( vals.[name] ) ) ) ) +
N' cannot be displayed' + NCHAR(13) + NCHAR(10) + NCHAR(9) + N'END'
END COLLATE Chinese_PRC_BIN As definition
From [THIS4_YB2].[sys].[all_sql_modules] As mods WITH ( NOLOCK ) RIGHT JOIN [THIS4_YB2].[sys].[all_objects] As objs WITH ( NOLOCK )
ON mods.[object_id] = objs.[object_id]
JOIN [master].[dbo].[spt_values] As vals WITH ( NOLOCK )
ON CONVERT ( NVARCHAR(2) , objs.[type] ) = SUBSTRING ( vals.[name] , 1 , 2 ) COLLATE Chinese_PRC_BIN
And vals.[type] = N'O9T'
Where objs.[object_id] > 0
And CONVERT ( NVARCHAR(2) , objs.[type] ) Not In ( N'C' , N'D' , N'IT' , N'U' , N'V' , N'F' , N'K' , N'L' , N'R' , N'SN' ) ) As nodef
ON obj.[schema_id] = nodef.[schema_id]
And obj.[object_id] = nodef.[object_id]
UNION
Select DB_ID() [db_id],0 [schema_id],0 [object_id],N'L' [QSItype],N'DB' [type],DB_NAME() [db_name],
N'' [schema_name],DB_NAME() [obj_name],0,1,DB_NAME();
