performance impact
xdai
Posts: 98
currently i have sql response enable on one of the server, not sure what cause the CPU run up (1465054), and it use tempdb to run some query, such as
DBCC TRACEON WITH NO_INFOMSGS
CREATE TABLE #dbccstat
(
TraceFlag INT,
Status INT,
)
INSERT INTO #dbccstat EXEC('DBCC TRACESTATUS(1204) WITH NO_INFOMSGS')
DECLARE @status INT
SELECT @status = Status FROM #dbccstat
IF @status = 0
BEGIN
DBCC
so the tempdb size grow, is this normal?
DBCC TRACEON WITH NO_INFOMSGS
CREATE TABLE #dbccstat
(
TraceFlag INT,
Status INT,
)
INSERT INTO #dbccstat EXEC('DBCC TRACESTATUS(1204) WITH NO_INFOMSGS')
DECLARE @status INT
SELECT @status = Status FROM #dbccstat
IF @status = 0
BEGIN
DBCC
so the tempdb size grow, is this normal?
Comments
SQL Response uses DBCC trace flags to get information about activities on the SQL Server, however, I don't see how this one would cause noticeable tempdb growth. Trace 1204 is used to get information about deadlocks when they happen on the server. http://doc.ddart.net/mssql/sql70/ta-tz_7.htm