Where does Profiler store its temporary data in

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Where does Profiler store its temporary data in SQL Server 2005?

Answer
In the directory stored in the system variable TEMP.

Explanation
Profiler uses the location specified for the TEMP system variable.

(Continued on next question...)

Other Job Interview Questions

• In Reporting Services 2005, how is Report Builder typically deployed to end users?
• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• What does this return on SQL Server 2005? select NEWSEQUENTIALID()
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• In SQL Server 2005, which network protocols use endpoints?
• What does this code return? select 6 | 7 Figure it out without running it.
• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• More...