home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,105 of 19,505   
   zmpmag3-msql@yahoo.com to Erland Sommarskog   
   Re: SQL 2008 Cache File Relocation?   
   25 Jan 11 16:21:16   
   
   On Tue, 25 Jan 2011 21:37:31 +0100, Erland Sommarskog    
   wrote:   
      
   >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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca