How can we help you today? How can we help you today?

performance impact

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?
xdai
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi,

    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
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.