Hi.
I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2
(also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process only
allocates max 90-100MB. That's why big SQLs run very slow.
I checked the setup variables on the managment console and everything seems
to be ok. I don't know how to solve this problem.
Please help!
Ulf 5 2454
Hopefully the following helps, check their recommedations: http://www.microsoft.com/technet/pro...hysdbstor.mspx http://www.microsoft.com/technet/pro...n/sqlops6.mspx
"Ulf Dingler" <u.*******@lasa rtes.dewrote in message
news:6f******** ****@mid.uni-berlin.de...
Hi.
I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2
(also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process
only allocates max 90-100MB. That's why big SQLs run very slow.
I checked the setup variables on the managment console and everything
seems to be ok. I don't know how to solve this problem.
Please help!
Ulf
Ulf Dingler (u.*******@lasa rtes.de) writes:
I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2
(also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process
only allocates max 90-100MB. That's why big SQLs run very slow.
I checked the setup variables on the managment console and everything
seems to be ok. I don't know how to solve this problem.
What does "sp_configu re 'max server memory'" report? And "sp_configu re
'awe enabled'"?
Have you check in Task Manager whether there is any other process that
takes up a lot of memory?
How big are your databases?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
"Erland Sommarskog" <es****@sommars kog.seschrieb im Newsbeitrag
news:Xn******** ************@12 7.0.0.1...
What does "sp_configu re 'max server memory'" report? And "sp_configu re
'awe enabled'"?
Have you check in Task Manager whether there is any other process that
takes up a lot of memory?
awe is enabled but i read, that awe is not important for 64bit. sp_configure
'max server memory' reports 2147483647. no other process takes more than
60mb and there is a lot of memory free (10GB) for the sql server process.
How big are your databases?
the databases are very big. 7GB/9GB/70GB
Ulf Dingler (u.*******@lasa rtes.de) writes:
awe is enabled but i read, that awe is not important for 64bit.
That's correct. It's not supposed to have any effect at all, but it
does affect something, although I don't recall exactly what.
On 32-bit when you have AWE enabled, and look in task manager, you don't
see the true size of SQL Server, as the AWE memory is not included. Maybe
there is a similar effect on 64-bit? Could you run DBCC MEMORYSTATUS and
post the output?
the databases are very big. 7GB/9GB/70GB
Ehum, 70GB could be called mediums-sized, but it does not really
qualify as "very big". Not that it matter here. Unless the data-access
pattern is very concentrated, it seems unlikely that SQL Server would
not need more memory than 100 MB.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Ulf Dingler wrote:
I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2
(also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process only
allocates max 90-100MB. That's why big SQLs run very slow.
I checked the setup variables on the managment console and everything seems
to be ok. I don't know how to solve this problem.
You can force SQL's memory usage by setting minimum and maximum to the
same value (say 10 GB, leaving the other 2 GB for the other processes). This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
|
by: SoWright |
last post by:
I am running a 32bit VB .Net application in Windows Server 2003 64bit
edition. The application uses the function System.IO.File.Exists() to check
the existance of a file in the directory "%systemroot%\system32". However,
the call always fails becuase WOW64 is redirecting the existance check to
"%systemroot%\SysWOW64". Is there any way I can bypass the WOW64 File
Redirector?
|
by: Frank Uray |
last post by:
Hi all
I have written a WindowsService in C# 2005.
I am running this service on a 64bit Windows Server 2003
and I like to run some Interop.Excel within this service.
It seams that Interop does not run in 64bit mode ...
I have tried to compile the service as x86 but it does not help,
the service is still running in 64bit mode ...
|
by: Brian Delahunty |
last post by:
I'm having a bit of a weird problem and I've spent the last few hours
scouring the web trying to solve this before coming here.
Here is the problem:
I get 404 errors for all ASP.NET 2.0 content trying to be served from IIS.
Setup:
IIS 6 (64 bit)
Windows Server 2003 64bit
ASP.NET 2.0 (64 bit)
|
by: Eric |
last post by:
Hi,
I want to generate a dll for x64. In the project, I specify the
platform target x64 but VS2005 use the win32 framework. Here is the
warnings that I get :
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Csc.exe /noconfig
/nowarn:1701,1702 /platform:x64 /errorreport:prompt
/baseaddress:285212672 /define:TRACE;DEBUG
/reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll
| |
by: Alaashamas |
last post by:
I am still testing the different features I can use to connect from SQL Server 2005 to ORACLE.
Actually the scenario that I have now is the following:
I have the SQL Server 2005 64Bit installed on Windows 2003 Server 64 bit, and I have the OracleClient 10g for 64 bit installed
I created an SSIS package
I have added an OLEDB Source, the connection is to ORALE 8 database:
I used OLEDB provider for oracle and I provided the name of...
|
by: =?Utf-8?B?U2FpIFZhamph?= |
last post by:
Hi
I am working on a website in asp.net 2.0 with 2.0 framework and would like
to deploy this to a windows 2003 64bit server and want it to run under 64bit
framework., Is this really possible? can anyone let me know what must be done
to achieve this? I am currently getting this error....
Server Error in '/Contest' Application.
--------------------------------------------------------------------------------
|
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= |
last post by:
I have a web server 32 bit and SQL server 2005 64bit .
Does msdtc support SQL server 2005 64bit with web server 32 bit?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |