Memory Allocation for 64 bit

I have a client experiencing problems with SQL Server 2005 64 bit
(sp1). The server has 4 gigs of memory available, however I can not
increase the memory allocated via management studio past 2 gigs. When
I look at the .exe in task manager, I see that service is using about
3.5 gigs. Can I just go into sp_configure and set it to what I need?
Not sure if this matters...the processors are made by AMD. Please
advise...
I think if you check that value in management studio you will see that is
not 2 gigs but a much higher number.
Andrew J. Kelly SQL MVP
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegro ups.com...
>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>
|||Hello,
SQL Server 2005 supports dynamic allocation of AWE mapped memory on Windows
Server 2003. In Windows 2003 with SQL Server 2005 64 bit, no need to
do any changes to utilize more than 4 GB RAM.
See the below URL which details.
http://msdn2.microsoft.com/en-us/library/ms190731.aspx
Thanks
Hari
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegro ups.com...

>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>
|||On 30.03.2007 01:32, abraceyiii@.yahoo.com wrote:
> I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
Are you maybe trying to administer a 64 bit version with a 32 bit
client? Maybe that has some built in limitations. Just a wild guess.
robert
|||On Apr 2, 2:05 am, Robert Klemme <shortcut...@.googlemail.com> wrote:
> On 30.03.2007 01:32, abracey...@.yahoo.com wrote:
>
> Are you maybe trying to administer a 64 bit version with a 32 bit
> client? Maybe that has some built in limitations. Just a wild guess.
> robert
thanks...i will look elsewhere

Memory Allocation for 64 bit

I have a client experiencing problems with SQL Server 2005 64 bit
(sp1). The server has 4 gigs of memory available, however I can not
increase the memory allocated via management studio past 2 gigs. When
I look at the .exe in task manager, I see that service is using about
3.5 gigs. Can I just go into sp_configure and set it to what I need?
Not sure if this matters...the processors are made by AMD. Please
advise...I think if you check that value in management studio you will see that is
not 2 gigs but a much higher number.
Andrew J. Kelly SQL MVP
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegroups.com...
>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>|||Hello,
SQL Server 2005 supports dynamic allocation of AWE mapped memory on Windows
Server 2003. In Windows 2003 with SQL Server 2005 64 bit, no need to
do any changes to utilize more than 4 GB RAM.
See the below URL which details.
http://msdn2.microsoft.com/en-us/library/ms190731.aspx
Thanks
Hari
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegroups.com...

>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>|||On 30.03.2007 01:32, abraceyiii@.yahoo.com wrote:
> I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
Are you maybe trying to administer a 64 bit version with a 32 bit
client? Maybe that has some built in limitations. Just a wild guess.
robert|||On Apr 2, 2:05 am, Robert Klemme <shortcut...@.googlemail.com> wrote:
> On 30.03.2007 01:32, abracey...@.yahoo.com wrote:
>
> Are you maybe trying to administer a 64 bit version with a 32 bit
> client? Maybe that has some built in limitations. Just a wild guess.
> robert
thanks...i will look elsewhere

Memory Allocation for 64 bit

I have a client experiencing problems with SQL Server 2005 64 bit
(sp1). The server has 4 gigs of memory available, however I can not
increase the memory allocated via management studio past 2 gigs. When
I look at the .exe in task manager, I see that service is using about
3.5 gigs. Can I just go into sp_configure and set it to what I need?
Not sure if this matters...the processors are made by AMD. Please
advise...I think if you check that value in management studio you will see that is
not 2 gigs but a much higher number.
--
Andrew J. Kelly SQL MVP
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegroups.com...
>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>|||Hello,
SQL Server 2005 supports dynamic allocation of AWE mapped memory on Windows
Server 2003. In Windows 2003 with SQL Server 2005 64 bit, no need to
do any changes to utilize more than 4 GB RAM.
See the below URL which details.
http://msdn2.microsoft.com/en-us/library/ms190731.aspx
Thanks
Hari
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegroups.com...
>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>|||On 30.03.2007 01:32, abraceyiii@.yahoo.com wrote:
> I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
Are you maybe trying to administer a 64 bit version with a 32 bit
client? Maybe that has some built in limitations. Just a wild guess.
robert|||On Apr 2, 2:05 am, Robert Klemme <shortcut...@.googlemail.com> wrote:
> On 30.03.2007 01:32, abracey...@.yahoo.com wrote:
> > I have a client experiencing problems with SQL Server 2005 64 bit
> > (sp1). The server has 4 gigs of memory available, however I can not
> > increase the memory allocated via management studio past 2 gigs. When
> > I look at the .exe in task manager, I see that service is using about
> > 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> > Not sure if this matters...the processors are made by AMD. Please
> > advise...
> Are you maybe trying to administer a 64 bit version with a 32 bit
> client? Maybe that has some built in limitations. Just a wild guess.
> robert
thanks...i will look elsewhere

Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4

I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
Manager/Total Server Memory). I would like to allocate nearly all of
the available memory on the machine to SQL Server.
I seem to have the same symptons described in this MS article-
http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
Qualifying Products" error when I try to install the HOTFIX.
Any help would be greatly appreciated.
NickHi
appologies if this is an obvious response - are you using std or ent?
the hotfix is for ent and dev editions.
nicholasbecker@.gmail.com wrote:
> I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
> Manager/Total Server Memory). I would like to allocate nearly all of
> the available memory on the machine to SQL Server.
> I seem to have the same symptons described in this MS article-
> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
> Qualifying Products" error when I try to install the HOTFIX.
>
> Any help would be greatly appreciated.
>
> Nick
>|||Look here on the UPDATE section
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
Have you applied this hotfix?
Ben Nevarez, MCDBA, OCP
Database Administrator
"nicholasbecker@.gmail.com" wrote:
> I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
> Manager/Total Server Memory). I would like to allocate nearly all of
> the available memory on the machine to SQL Server.
> I seem to have the same symptons described in this MS article-
> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
> Qualifying Products" error when I try to install the HOTFIX.
>
> Any help would be greatly appreciated.
>
> Nick
>|||I'm using Enterprise editiion (req's for a cluster).
The link seems to refer to SQL Server SP4. We are have installed sp4
if that's the hotfix you're referring to.
Nick

MDX Query Tool Problem

I am trying to get to grips with cube reporting and am running the MDX Query
Tool against AdventureWorksDW on SQL 2005 sp1, Standard Edition (I am not
fluent in MDX). No matter what dimensions I drag on, the only output I can
get is a single cell / report services field.
For example, if I drag on the geography.country dimension and Sales
Order.Order Count measure, I just get a count of all orders.
--
simonI have found some sample MDX code for AdventureWorks that does work with the
Report Builder. Clearly I need to get more proficient with writing good
queries.
--
simon
"simon p" wrote:
> I am trying to get to grips with cube reporting and am running the MDX Query
> Tool against AdventureWorksDW on SQL 2005 sp1, Standard Edition (I am not
> fluent in MDX). No matter what dimensions I drag on, the only output I can
> get is a single cell / report services field.
> For example, if I drag on the geography.country dimension and Sales
> Order.Order Count measure, I just get a count of all orders.
> --
> simon

MDX in reporting services

having hard time solving this simple Query.
I am using the following Query in reporting services with sp1 installed .
="SELECT {[Measures].[Calls Handled],[Measures].[Transfer In
Calls],[Measures].[Transfer Out Calls]} on Columns,
NONEMPTYCrossjoin([DestinationDim].[Destination Site
Desc].members,[DestinationTetraGraph].[Destination Tetra Graph Desc].members)
on rows
from
ICMDestinationService where "+Parameters!period.value+""
When i give the parameter it is executing correctly.
When I pass the parameter the resulting
The error i am getting is
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'Site_Dim'. (rsErrorExecutingCommand)
Get Online Help
Syntax error, expecting FROM, near: 'ICMDestinationService where
[TimeDim].[All TimeDim]
when i pass the same string without parameters i am getting the results.
Any Idea's or help will be Appreciated.
Thanks,
yalamanFinally I fot the solution. hope no one will wonder 2 days for getting sytax
error.
The answer -- there should be even spaces within the Query(I dont know
why?It is with interpreter )
Copy the query in notepad and adjust all the spaces between the Query and
Past it works.
Its is silly
SQL reporting team should address this type of errors.