.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

What are the memory limits of SQL Server 2008 Workgroup edition (32 bit/non-R2) running on Windows S

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

We have a situation where one of our customers is running Windows 2003 Enterprise Edition 32bit with 8 GBs of physical RAM. Upgrading to Windows Server 2008 64bit is not an immediate option (although I wish it were). All the documentation about SQL Server 2008 Workgroup edition indicates that the new version will address 4 GBs of memory however it does not distinguish between 32bit vs 64bit.

Previously we have run SQL Workgroup 2005 under Windows 2003 and have applied the /3gb switch in boot.ini to get SQL to recognize the maximum amount of memory possible. Now that we are using SQL 2008 with the /pae switch, do we need to still specify the /3gb switch or can SQL 2008 32bit actually see more than the 3GBs and address 4? I haven't been able to find any information on this configuration.




View Complete Post

More Related Resource Links

MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems

SP 2010 and Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition

Hello,Will it be possible to install SharePoint 2010 on Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition?Thanks

In windows server 2008 standard edition feature Failover clustering is not looking

In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

How to install Sql server 2008 Enterprise edition in windows 7 (32 bit system)

am install Sql server 2008 SP1 But same Problem again Plz Give me Reply Plzzzzzzzzzz Which edition Support in windows 7?

SQL Server 2008 r2 developer RTM edition not installing on windows 7 64 bit machine with latest serv


This machine had sql server 2008 installed.  I removed it since the upgrade would not work.   The machine currently doesn't have any sql installs.    The error fails during the Setup Support Files step.    Any help on this would be greatly appreciated.  I've included last part of file since you can only include 60k chars here.

2010-09-24 10:14:14 Slp: C:\sql2008r2\x64\FixSqlRegistryKey_x64.exe exit code: 0
2010-09-24 10:14:14 Slp: Launching external tool: C:\sql2008r2\x64\FixSqlRegistryKey_x86.exe
2010-09-24 10:14:14 Slp: ------------------------------------------------------------
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag2 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect -

Remove SQL Server 2008 R2 Express Edition from Windows 7 professional


Are there any good practices to follow in order to remove/uninstall SQL Server 2008 R2 Express Edition from Windows 7 professional laptop? Thanks for your comments.




SQL Server 2008 R2 Standard edition running from one Core


Hi, I have a client who we just upgraded to Win 2008 R2 Standard Edition and SQL 2008 R2 Standard Edition

They are complaining about System performance. 

Looks like SQl runs only on 1 core, maybe sometime 2 which is maxed out.

"Automatically set Processors affinity mask for all processors" is checked and also

"Automatically set I/O affinity mask for all processors" is checked...

The server was maxed out with memory a few days ago but looks to me that that is something taht SQL 2k8 R2 does. The server has got 16GB ram

Pretty urgent. Got 3 hours to solve it.



Failures in running Repair for 2008 SQL Server standard edition


Dear users,

2008 SQL Server Standard edition.


While running Repair I got below failures,

1. Upgrade failed due to the following error. The error code is :-214747259.Message:Unspecified error

2. The process cannot access the file 'C:\Windows\system32\perf-SQLSERVERAGENT-sqlagtctr10.0.1600.22.dll' because it is being used by another process.

3. The service did not start due to a logon failure.

I wonder what causes the failures and what I should do to fix them.


Could you tell me what to do?

Thank you,


SQL Agent - Running SSIS Package - Windows Server 2008/Windows 7 - Messenger Services


We have tried to run a SQL job for SSIS Package. But it failed during the execution with the error "[364] The Messenger service has not been started - NetSend notifications will not be sent". But in the job, no notifications have been configured and in windows server 2008/Windows-7 there is no messenger service at all.

When we search for the the messenger service in windows 7/windows server 2008, we found that service is not in both the OS and it was replaced by msg.exe. 

Any help or workaround would be appreciated.

Thanks in advance.

PS: The normal SQL jobs other than SSIS are working fine without any error.

Vijay Pandurangan

Running ASP.Net 2.0 on Windows 2008 Server


Hi - I've got an ASP.Net 2.0 application running on a Windows 2003 server.  It makes use of the Microsoft.ApplicationBlocks.Data reference, but there are no special bells and whistles, no AJAX, or other add-ins.  The application connects to a SQL 2000 database on a different server.  My boss wants to know if we can upgrade the server where the ASP.Net application runs to Windows 2008.  Are there any issues I should be aware of?

Thanks much! 

Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.

SQL Server 2008 R2 on Windows Server 2008 R2 Memory Usage issues and not giving memory back


Okay so i have a physical server i am trying to replace with a virtual server. Its doing a large load process every night, about 190GB on one disk.

The VM is:

On vSphere 4.1 ESXi

O/S is Windows Server 2008 R2 Enterprise

SQL version is SQL Server 2008 R2 Enterprise.

4 vCpus

Now 20GB of memory

Disks assigned to this virtual are all seperate LUNs except for the O/S which is on a shared LUN which is not busy. So 1 LUN/Datastore per 'disk drive on this SQL virtual. Data/Log/TempDB/Backup are on their own LUNs.

All the recommended exclusions are in place for McAfee on a SQL Server.

ESXi 4.1 Enterprise host is not overcommitted. Has 4 x 6core 2.6Ghz AMD processors. BL685c G6 and 128GB of memory. Almost nothing else is running at the time i am testing this load and host is not overcommited or stressed or anywhere near it.

SQLServer process shows 127,236K Working Set and 130,040K Peak working set and memory Private working set 88,828k and Commit Size of 302,792k.

It seems when i check the memory usage in task manager it doesn't show much. In Windows 2003 X64 in would show the GB being used, like 8GB right in task manager. But i don't see that in Windows 2008 R2 task manager. I downloaded SysInternals and it shows the memory on the Windows 2008 r2 box as 15Gb of AWE memory. How can this be? The case is th

Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


SQL Server 2008 R2 -Windows 7 Enterprise edition



Can i install SQL Server 2008 R2 64bit enterprise edition on windows 7 enterprise edition machine??


Will SQL Server 2008 Developer Edition install on Windows 7 64-bit Professional? OS not listed on re

I just purchased Windows 7 Professional  for installation on an Intel 64-bit laptop. I planned on purchasing SQL Server 2008 Developer Edition but noticed that Windows 7 Professional is missing on the requirements list. 

I was hoping someone here could verify that SQL Server 2008 Developer Edition will install on the OS mentioned above. 

Here's the requirements page I was viewing:


Microsoft SQL Server 2008 Standard Edition for Small Business supports Windows 7 Pro ?


Microsoft SQL Server 2008 Standard Edition for Small Business supports Windows 7 Pro ?

I have try to install its failed at Rule check is their any work around?

many thanks



Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e



I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend