running sql profiler

Question

running sql profiler

ramyours2003

SSChampion

Points: 12268
More actions
November 4, 2015 at 3:35 am

#302002

is running a profiler will make the tempdb grow?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

No. Not unless you selected the option to save to table and specified the TempDB database

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 2

ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?

Depending on where you run it from and how you run it, it can make a file on your server at the OS level that can, given a long enough run time, fill your server hard-disk (I don't remember if it will be the C: Drive or the drive that SQL Server itself is installed). And, yeah... I've actually seen it happen about 6 years ago.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Jeff Moden (11/4/2015)
ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?
Depending on where you run it from and how you run it

Profiler can fill up the local C drive (local being the machine that it's been run on), it can degrade performance, it can crash the server, but it doesn't outright use TempDB.