Hi,

When i run an mdx using openquery, it acts quite weird. Sometimes i get the
message "there is insufficient memory to run this query", sometimes i get the
first results, but followed with blank fields (not even NULL).

Anyone any idea ?

Thx

try to use -g startup option for sql server service. I use -g1024.

"Koen" <Koen (AT) discussions (DOT) microsoft.com> wrote

Are you sure about this ? My sql server has 4 GB ram, and its configurated to
use
3808 MB already ?

Grtz,

"Ramunas Balukonis" wrote:

a little update:

when i check the log files, i see this message :

006-02-22 14:24:45.74 spid56 Query Memory Manager: Grants=1 Waiting=0
Maximum=154776 Available=154718
2006-02-22 14:24:48.99 spid66 WARNING: Failed to reserve contiguous
memory of Size= 65536.
2006-02-22 14:24:49.00 spid66 Buffer Distribution: Stolen=768 Free=74
Procedures=2528
Inram=0 Dirty=45960 Kept=0
I/O=0, Latched=80, Other=158998
2006-02-22 14:24:49.00 spid66 Buffer Counts: Commited=208408
Target=208408 Hashed=205038
InternalReservation=244 ExternalReservation=0 Min Free=128
2006-02-22 14:24:49.00 spid66 Procedure Cache: TotalProcs=826
TotalPages=2528 InUsePages=1334
2006-02-22 14:24:49.00 spid66 Dynamic Memory Manager: Stolen=3296 OS
Reserved=1688
OS Committed=1653
OS In Use=1651
Query Plan=2494 Optimizer=35
General=2054
Utilities=15 Connection=196
2006-02-22 14:24:49.00 spid66 Global Memory Objects: Resource=1767
Locks=74
SQLCache=97 Replication=2
LockBytes=2 ServerGlobal=45
Xact=23

"Koen" wrote:

Can you run that query in rowsetviewer returning a rowset? Perhaps the size
of the response is very large?

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Koen" <Koen (AT) discussions (DOT) microsoft.com> wrote