SQL Server Manageability Series: how to change the default path of .cache files of a data collector? #sql #mdw #dba

Posted by ssqa.net on SQL Blogcasts See other posts from SQL Blogcasts or by ssqa.net
Published on Wed, 15 Jun 2011 11:50:00 GMT Indexed on 2011/06/20 16:30 UTC
Read the original article Hit count: 326

How to change the default path of .cache files of a data collector after the Management Data Warehouse (MDW has been setup? This was the question asked by one of the DBAs in a client's place, instantly I enquired that were there any folder specified while setting up the MDW and obvious answer was no as there were left default. This means all the .CACHE files are stored under %C\TEMP directory which may post out of disk space problem on the server where the MDW is setup to collect. Going back...(read more)

© SQL Blogcasts or respective owner

Related posts about SQL Server

Related posts about best practices