SQL Server 2005 with Multiple Instances and Memory Usage


    Sponsored Links


  • 1. Can not connect to SQL 2008 Express ON same LAN
    Ensure that TCP/IP protocol is enabled and Browser Service is running. You can configure it using SQL Server Configuration Manager. Note: You'll need to restart your SQL Server service so that this new setting to take effect. -- Ekrem soy "jpBless" < XXXX@XXXXX.COM > wrote in message news:eO% XXXX@XXXXX.COM ... >I installed SQL 2008 Express on XP Workstation. I can connect to SQL >Express on the XP box via ODBC and ADO. But I can't connect to SQL Server >from any other computer on the same LAN. Is there any setting I need to do >before another computer could connect to SQL server Express on another >computer. > > Just to be sure; I installed another copy a Vista box... same result. What > in the world am I doing wrong... someone please help. > > >
  • 2. sql 2008 install problem visual studio 2008
    Trying to install SQL Server 2008 Enterprise on my dev machine, which is on Windows XP Pro SP3. SQL Server install hangs and gives me an error saying that because I have VStudio 2008, I need SP1 for it (VStudio). So I installed it (and it takes a looooooong time), restarted, and then tried the SQL Server install again. Once again, it failed, for the same reason. So I started VStudio, clicked the Help/About, and the splash screen says Visual Studio (whatever numbers are there) then it's followed by "SP", but no number. So I restarted just to be sure, and it's the same. Basically I cannot install SQL Server 2008 because my install of SP1 for Visual Studio isn't showing. What can I do? I have googled and haven't seen any mention of this problem.
  • 3. Error while installing "SQL Server Native Client " or "managem
    I'm getting the same error when unintalling one of the two instances of sql server. Details are below, which didn't make sense to me. I just downloaded the installation package from the MS web-site, I didn't have any control on how the MSI file was named: Details Product: SQL Server ID: 50000 Source: setup.rll Version: 10.0 Component: SQL Server Native Client Message: A network error occurred while attempting to read from the file '%.*ls'. Explanation An attempt was made to install (or update) SQL Server Native Client on a computer where SQL Server Native Client is already installed, and where the existing installation was from an MSI file that was not named sqlncli.msi. User Action To resolve this error, uninstall the existing version of SQL Server Native Client. To prevent this error, do not install SQL Server Native Client from an MSI file that is not named sqlncli.msi.
  • 4. Migrating tables from sql 2005 standard to sql 2005 enterprise x64
    Are there any tools or processes to copy the default instance and tables from sql 2005 standard 32 bit to sql 2005 enterprise x64?
  • 5. Setup User
    Hello, Is there a way to tell what user installed sql server? Any help appreciated! Thanks in advance

SQL Server 2005 with Multiple Instances and Memory Usage

Postby housequake » Fri, 16 Feb 2007 08:08:04 GMT

Despite reading numerous posts regarding SQL Server 2005 memory
configuration I'm still confused about my situation.  I am looking at
running multiple instances of SQL Server 2005 Standard on a box with
8gb ram and Windows 2003 Enterprise (everything is 32-bit).  Will the
multiple instances be crowded into the lower 4gb of ram because
standard edition doesn't support AWE?  Or does the AWE option just
affect how much memory a single instance can handle?


Similar Threads:

1.Memory configuration for multiple instances SQL 2005 Std (32 bits)


I have a server with 8 GB RAM and 4 HT cpu (8 virtuals cpu), it is running 
Win2003 EE(32 bits) and 3 SQL 2005 Std instances.

This is the boot.ini file
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, 
Enterprise" /fastdetect  /PAE 

AWE is enabled for all the instances.

I need to know if I have to setup something else for memory configuration. 
(Minimun server memory, Maximum server memory, /3GB)


2.memory usage in SQL Server Analysis Services 2005 (SSAS)


I am running the enterprise edition of Analysis services 2005. I have a
cube that has 4 dimensions (including the date) and 2 years of test
data. (The data generated is pretty dense as it was generated by an
automated program. And we expect the rpoduction data to be this dense
as well.)

I was able to setup the cube and process around 43 million rows easily
(within about 20 minutes).

I am facing performance issues while querying this data. I am new to
this version of analysis services.  When I say performance issues, I
mean, it is really slow. More than 15-20 seconds to retrieve data for a
single dimension and the corresponsing measures.  I investigated
further and found that the CPU on the server spikes to 100%  when I
issue a query. However, the memory used is only 55 MB. My server has 2
GB of RAM. Is there anyway to tune this or speed this up?. The cube
size on disk is less than 1 GB. So I am finding it very difficult to
accept that this is the best we can do with this.

Your help is highly appreciated. 


3.SQL Server 2005 express high memory usage


We have SQL Server 2005 express installed on a Windows 2003 webserver.
After some days the memory usage of sqlservr.exe gets really high. It
uses about 1.500.000K of memory while there's 2GB installed in the

There's some activity on the webserver but it not a really high
traffic site.
Is this normal to SQL server 2005? And can we do something to prevent

best regards,

4.Memory Usage Problem on 64 Bit SQL Server 2005 ent Cluster

My SQL Server Ent 2005 64Bit Active / Passive Cluster is using 16.3GB of RAM 
and there is only 16GB in the server. 

I have the max memory for SQL server set at 12582912 (12GB) but the process 
is running at 15,388,052 ignoring the maximum settings.

Thus the server is swapping memory to disk.

How can i make sure the SQL server is limited in its memory usgage if it is 
ignoring the setting.



5.SQL Server 2005 Express Memory usage

I have added 1GB of RAM to my workstation, bring the total to 1.5GB.
When Express is running, Task manager shows 760MB in use with 1.5MB
available.  The usage is close to what it was before the upgrade.

How do I persuade Express to use its maximum of 1GB?



6. How to check the current usage of memory by SQL SERVER 2005

7. setting Memory Usage of SQL 2000 instances

8. Memory settings/considerations when running multiple instances of SQL Server



Who is online

Users browsing this forum: No registered users and 94 guest