What are the challenges you face when working across database platforms? Take the survey
Options

performance impact

xdaixdai Posts: 98
edited July 21, 2009 12:06PM in SQL Monitor Previous Versions
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?

Comments

Sign In or Register to comment.