patternsqlMinor
Clear SQL Server Buffer after SSIS is done?
Viewed 0 times
aftersqlssisdoneclearserverbuffer
Problem
I'm new...
I've built an ETL process in SSIS that takes 46 flat files and loads them into stg.Suppliers and triage.Suppliers. Then another solution runs that applies Business Rules. And then the final solution moves the good stuff from stg.Suppliers into pdw.Suppliers.
My question is when I run all this (once a week); is it good (best practice) to clean up the buffer for the stg.Suppliers table? I notice that when I run this query that it's the number one cached_pages_count.
If yes, how?
I've built an ETL process in SSIS that takes 46 flat files and loads them into stg.Suppliers and triage.Suppliers. Then another solution runs that applies Business Rules. And then the final solution moves the good stuff from stg.Suppliers into pdw.Suppliers.
My question is when I run all this (once a week); is it good (best practice) to clean up the buffer for the stg.Suppliers table? I notice that when I run this query that it's the number one cached_pages_count.
If yes, how?
Solution
Leaving it in cache will have no downsides since SQL Server does a great job managing the cache without interference. In fact, it may be beneficial to keep some of those pages cached.
Are you attempting to solve some problem?
Are you attempting to solve some problem?
Context
StackExchange Database Administrators Q#166882, answer score: 4
Revisions (0)
No revisions yet.