SQL 2008 Cache File Relocation?

#11

On Tue, 25 Jan 2011 21:37:31 +0100, Erland Sommarskog <esquel (AT) sommarskog (DOT) se> wrote:

Quote:

Looking at the screen shots you sent me, I realise that you are running
the Mangement Data Warehouse. It is probably not very interesting to run
on a development server.

When you configure the Data Collector, you are asked to specify a directory
for the cache files, and says that if you leave it empty it will use the
TEMP directory for the service account. I set up MDW and started the jobs,
and sure enough those .cache files started to turn up.

I guess that you once set up the MDW to see what it was, and then forgot
all about it. Go the Management node in Object Explorer, and select Data
Collector.

I have not been able to figure how you remove all the configuration,
but at least you can select "Stop Data Collection" from the context menu.

OK, will give that a try. Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2008 Cache File Relocation?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: SQL 2008 Cache File Relocation? - 01-25-2011 , 03:21 PM