508 Compliance?

Do you definitely need scripting enabled for anything to work in RS 2005?.

We have a govt client..so basically if the answer is not, we cannot use RS2005.

thanks.

If you are using the Web Interface, you will need scripting enabled for your browser. The Winforms control does not require scripting enabled on the client.

4->8GB RAM Upgrade

I've recently upgraded a SQL 2000 Server from 4GB to 8GB of RAM. PAE, 3GB and AWE were enabled - AWE was set to ~6GB. The target SQL memory was around 4.1GB and the total SQL memory in use matched that. The VERY odd thing is this did nothing at all to help performance. It almost seems that it hampered it. Any ideas out there?

Read about AWE in 2005...

It explains that the extra memory is not used for sorts and other things that you think it would be...

Bret.

|||

Sorry...I didn't make that clear...

In 2000 it is not used for sorts and other things that would increase performance...

3GB once again

Hi,
No there is no memory Limit for SQL Standard edition.. Using SP_CONFIGURE enable the option 'AWE Enabled' by setting the value to 1. After that set the max server memory
value to 3 GB for your SQL Server.
Thanks
Hari
"Axel Bender" <axel_bender@.t-online.de> wrote in message news:eq76ee$unj$00$1@.news.t-online.com...
Hi,
In the following configuration:
- SQL Server 2005 Standard SP1
- Windows 2003 Server R2 Standard
- 4 GB physical memory
- /3GB and /UserVA=3072 in boot.ini
the maximum amount of memory I can configure SQL Server to use (Options dialog) is 2 GB.
I found contradictory statements in the Web (see below) as well as in the MS SQL Server docs (limited by OS memory) for the Standard Edition.
Is there a 2 GB limit for SQL Server 2005 Standard on Windows 2003 Server?
thx
Axel
Hari
It is correct to 32 bit version as I understood . For 64 bit version you have to grant permission to the account on Lock Page memory and there is not reason to enable AWE.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message news:OQf$TaSSHHA.4260@.TK2MSFTNGP06.phx.gbl...
Hi,
No there is no memory Limit for SQL Standard edition.. Using SP_CONFIGURE enable the option 'AWE Enabled' by setting the value to 1. After that set the max server memory
value to 3 GB for your SQL Server.
Thanks
Hari
"Axel Bender" <axel_bender@.t-online.de> wrote in message news:eq76ee$unj$00$1@.news.t-online.com...
Hi,
In the following configuration:
- SQL Server 2005 Standard SP1
- Windows 2003 Server R2 Standard
- 4 GB physical memory
- /3GB and /UserVA=3072 in boot.ini
the maximum amount of memory I can configure SQL Server to use (Options dialog) is 2 GB.
I found contradictory statements in the Web (see below) as well as in the MS SQL Server docs (limited by OS memory) for the Standard Edition.
Is there a 2 GB limit for SQL Server 2005 Standard on Windows 2003 Server?
thx
Axel