Skip to content

improve-access-to-trace-data.md

Latest commit

 

History

History
38 lines (27 loc) · 2.23 KB

improve-access-to-trace-data.md

File metadata and controls

38 lines (27 loc) · 2.23 KB
title Improve Access to Trace Data
description Improve Access to Trace Data
author MashaMSFT
ms.author mathoma
ms.date 03/01/2017
ms.service sql
ms.topic how-to
helpviewer_keywords
Profiler [SQL Server Profiler], space
SQL Server Profiler, space
space [SQL Server], SQL Server Profiler

Improve Access to Trace Data

[!INCLUDE SQL Server] [!INCLUDEssSqlProfiler] uses space in the temp directory to improve access to trace data. [!INCLUDEssSqlProfiler] requires at least 10 megabytes (MB) of free space. If free space drops below 10 MB while you are using [!INCLUDEssSqlProfiler], all [!INCLUDEssSqlProfiler] functions stop.

When [!INCLUDEssSqlProfiler] uses space in the temp directory, this space usage may cause the temp directory to grow rapidly. To avoid file-growth problems, you can place the temp directory on a drive that is not a system drive by changing the value for the TEMP environment variable.

The following procedure describes how to change the value for the TEMP environment variable in most Microsoft Windows operating systems. For more information about setting environment variables, see your Windows operating system documentation.

To change the TEMP environment variable in Windows operating systems

  1. On the Start menu, choose Control Panel, and then click System.

  2. In the System Properties dialog box, click the Advanced tab, and then click Environment Variables.

  3. Scroll down the list of System Variables, select the row that corresponds to the TEMP variable, and click Edit.

  4. In the Edit System Variable dialog box, enter the path and name of the drive and directory where you want the temp directory to be located.

  5. Click OK to save the change.

See Also

Start SQL Server Profiler
SQL Server Profiler