Memory

Hi, Experts
I have a sql server 7 on NT4.0 box.
2GB memory for the server.
Recently we can not do tape back up during the night.
we check CPU load is normal, but memory sql sever process
uses up to 1.5 GB of the 2GB. Is this normal?
It used to not take that much.
And the biggest database on that box is only 400MB.
Any advice.
Thanks
Laopangthis could be because of memory leaks, what service pack
you are running ? Is it possible for you to upgrade to sql
2000 or atleast upto sp4 for sql 7?
restart the server to resolve this temporarily.
hth
>--Original Message--
>Hi, Experts
>I have a sql server 7 on NT4.0 box.
>2GB memory for the server.
>Recently we can not do tape back up during the night.
>we check CPU load is normal, but memory sql sever process
>uses up to 1.5 GB of the 2GB. Is this normal?
>It used to not take that much.
>And the biggest database on that box is only 400MB.
>Any advice.
>Thanks
>Laopang
>.
>|||SQL Server will not release memory once it has grabbed it unless the OS
specifically asks for it. Just because the db is of a certain size does not
limit the amount of ram sql server can use. Sounds like it can easily get
away with using less so I suggest you set the MAX memory for sql server to
say 1GB and see how that works.
--
Andrew J. Kelly
SQL Server MVP
"laopang" <laopang@.hotmail.com> wrote in message
news:0cfd01c3b383$5b42d4a0$a001280a@.phx.gbl...
> Hi, Experts
> I have a sql server 7 on NT4.0 box.
> 2GB memory for the server.
> Recently we can not do tape back up during the night.
> we check CPU load is normal, but memory sql sever process
> uses up to 1.5 GB of the 2GB. Is this normal?
> It used to not take that much.
> And the biggest database on that box is only 400MB.
> Any advice.
> Thanks
> Laopang

MDX Query for the cube information?

Looking for some suggestions from SSAS experts.

Actually I had created few cubes in the server. I would like to retrieve the information about the available cubes and its dimensions & measures programmatically. I would like to use this metadata information in one of the .Net applications. Any idea how to do this?

Is it possible to write an MDX query which gives the names of the available cubes & its dimensions, measures in a server? Or is there any other approach for this?

Would appreciate any help in this regard.

Regards
Jacob

Hi,

ADOMD.NET should give you what you need take a look at http://msdn2.microsoft.com/en-us/library/ms123485.aspx. If you want to mange the objects then use Analysis Management Objects (AMO) http://msdn2.microsoft.com/en-us/library/ms345089.aspx.

Thanks

Giles

|||Thanks a lot !!!

Regards,
Jacob