SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

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

published 332 days, 21 hours, 2 minutes ago posted by

sa 341 days, 21 hours, 42 minutes ago

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

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 to basics...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: access, Best Practices, cache reports, cookbook, data collector, data files, DBA, management data warehouse, mdw, SQL Server, temp

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

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

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up