问题描述

SQL Profiler跟踪异常SC_MSSQL日志

最近系统使用有卡顿现象，数据库使用的是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]01DB_NAME();