 | |
Re: help!: can i turn off server query results caching in AS?
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: help!: can i turn off server query results caching in AS? -
07-17-2003
, 02:10 PM
|
hi i'm doing performance testing and i would REALLY love to be able to turn off server query results caching in Analysis Services so i can get an idea of how long a query takes to run against the actual data. right now, to get an "objective" query time i'm resetting OLAP service after each query run, but as you can imagine as i'm testing a lot of queries this adds significant time overhead. is there any way to configure Analysis Services to NOT CACHE results in ANY WAY? (to avoid PTS caching I use: ExecutionLocation=3, IsolationMode=1, ClientCacheSize=0 -- but this is only for client-side caching). thanks! |
#2
| |||
| |||
|
|
See if this helps you, http://tinyurl.com/h989 Look at Appendix C: How to flush query results cache. |
to flush the cache. what i want to know is how to avoid having to
flush the cache before each query -- and the only way to do that is to
turn off caching. so i want to know if there is a way to stop server
side query results caching.
anyone?
Quote:
|
John "groove_sf" <dockv (AT) hotmail (DOT) com> wrote in message news:ec0a53fa.0307171023.6ee40ef4 (AT) posting (DOT) google.com... hi i'm doing performance testing and i would REALLY love to be able to turn off server query results caching in Analysis Services so i can get an idea of how long a query takes to run against the actual data. right now, to get an "objective" query time i'm resetting OLAP service after each query run, but as you can imagine as i'm testing a lot of queries this adds significant time overhead. is there any way to configure Analysis Services to NOT CACHE results in ANY WAY? (to avoid PTS caching I use: ExecutionLocation=3, IsolationMode=1, ClientCacheSize=0 -- but this is only for client-side caching). thanks! |
#3
| |||
| |||
|
|
On Thu, 17 Jul 2003 12:10:28 -0700, "John Thomas" <ptjohn (AT) hotmail (DOT) com wrote: See if this helps you, http://tinyurl.com/h989 Look at Appendix C: How to flush query results cache. thanks for your response, but i think you missed my point. i know how to flush the cache. what i want to know is how to avoid having to flush the cache before each query -- and the only way to do that is to turn off caching. so i want to know if there is a way to stop server side query results caching. anyone? John "groove_sf" <dockv (AT) hotmail (DOT) com> wrote in message news:ec0a53fa.0307171023.6ee40ef4 (AT) posting (DOT) google.com... hi i'm doing performance testing and i would REALLY love to be able to turn off server query results caching in Analysis Services so i can get an idea of how long a query takes to run against the actual data. right now, to get an "objective" query time i'm resetting OLAP service after each query run, but as you can imagine as i'm testing a lot of queries this adds significant time overhead. is there any way to configure Analysis Services to NOT CACHE results in ANY WAY? (to avoid PTS caching I use: ExecutionLocation=3, IsolationMode=1, ClientCacheSize=0 -- but this is only for client-side caching). thanks! |
#4
| |||
| |||
|
|
Sorry. No, you can't. The best you can do is to run the script that was provided. It is significantly faster than restarting the entire service. |
in the white paper might be faster -- which it is. it's a pretty
significant improvement.
Quote:
|
-- Dave Wickert [MSFT] dwickert (AT) online (DOT) microsoft.com Program Manager BI Practices Team SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. "groove_sf" <dockv (AT) hot-NOSPAM-mail (DOT) com> wrote in message news:cq2fhvs76mrdhiut5kgrqh77nhtuars7kd (AT) 4ax (DOT) com... On Thu, 17 Jul 2003 12:10:28 -0700, "John Thomas" <ptjohn (AT) hotmail (DOT) com wrote: See if this helps you, http://tinyurl.com/h989 Look at Appendix C: How to flush query results cache. thanks for your response, but i think you missed my point. i know how to flush the cache. what i want to know is how to avoid having to flush the cache before each query -- and the only way to do that is to turn off caching. so i want to know if there is a way to stop server side query results caching. anyone? John "groove_sf" <dockv (AT) hotmail (DOT) com> wrote in message news:ec0a53fa.0307171023.6ee40ef4 (AT) posting (DOT) google.com... hi i'm doing performance testing and i would REALLY love to be able to turn off server query results caching in Analysis Services so i can get an idea of how long a query takes to run against the actual data. right now, to get an "objective" query time i'm resetting OLAP service after each query run, but as you can imagine as i'm testing a lot of queries this adds significant time overhead. is there any way to configure Analysis Services to NOT CACHE results in ANY WAY? (to avoid PTS caching I use: ExecutionLocation=3, IsolationMode=1, ClientCacheSize=0 -- but this is only for client-side caching). thanks! |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.