dbTalk Databases Forums  

Queries return incorrect values when VM usage is high

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Queries return incorrect values when VM usage is high in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Terry Field
 
Posts: n/a

Default Queries return incorrect values when VM usage is high - 10-01-2003 , 10:19 PM






Environment: AS 2000 SP3 (Standard) on Win2K SP3

We have a server running over 70 AS databases with an average of about 4
cubes in each. What we have found recently is that when the virtual memory
consumption for AS goes over about 1.6Gb, MDX queries start returning
incorrect values. Interestingly, the values that are wrong are only a very
small percentage of all results returned and they differ from the correct
results by only a small margin.

By restarting AS, the problems go away (for a while at least). Note that
this is on a production server, and no cube processing is done there.

Anyone seen anything like this before?

TerryF




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.