473,480 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

16GB Ram 64-bit server, what configuration to use?

We have a 64-bit clustered Windows 2003 R2 Enterprise
Edition x64 SP 2 running SQL 2005 Standard Edition SP2.
It has 2 Dual-Core AMD Opteron Processor 8212 2GHz.
The SQL Server databases files are on a SAN.

I configured SQL to use a fixed memory of MIN/MAX 12GB
and after one week I see in Task Manager that there is still
2GB of available physical memory.

I'm thinking about changing the setting to MIN 13GB and MAX
14GB to give SQL Server more RAM.

What setting do you think I should set it up for? It is a dedicated
SQL Server box and the only other things that run on this server
is RDP sessions, Anti-Virus, Backup Exec agent. So should I
reserve 2GB of RAM to OS and apps and 14GB for SQL Server
or I could go and use as much as 15GB of RAM?

Also, any experience with SAN fragmentation? There are some
saying SAN does not need to get defragmented. When I ran
windows defragmenter's Analyze button on the disk array where
the MDF file is, I saw it fragmented to 50,000 pieces!

What do you think?

Thank you
Jan 15 '08 #1
0 1631

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1522
by: Marc Poinot | last post by:
Did anybody use numarray on a 64 bits platform ? (e.g. SGI/Irix) The package works on our 64 bits platforms... using 32 bits mode, but not using 64 mode. Big crash in _ufunc... Is there a flag to...
1
2037
by: Hugo | last post by:
I have a dual boot machine, runs Win XP pro and Win XP Pro 64, XP boots from C and XP 64 boots from D. They both have VS 2005 Beta 2 installed. I have a webapp developed in Win XP (32) which...
56
4037
by: Dave Vandervies | last post by:
I just fixed a bug that some of the correctness pedants around here may find useful as ammunition. The problem was that some code would, very occasionally, die with a segmentation violation...
0
1289
by: Hugo | last post by:
I have a dual boot machine, runs Win XP pro and Win XP Pro 64, Win XP boots from C and Win XP 64 boot from D. They both have VS 2005 Beta 2 installed. I have a webapp developed in Win XP (32)...
13
4053
by: Mary Lei | last post by:
Does anyone know the link to obtain the tarball for db2 8.1 for solaris running on AMD 64 bit ? This is the entire db2 installation on a new system that does not have db2. Thanks.
10
10654
by: krunalb | last post by:
Hi, I am trying to shift unsigned long long value by 64 bits and this is what i get #include <stdio.h> int main() { unsigned short shiftby= 64;
14
2292
by: mosi | last post by:
Problem: how to get binary from integer and vice versa? The simplest way I know is: a = 0100 a 64 but: a = 100 (I want binary number) does not work that way.
1
2351
by: =?Utf-8?B?UGF1bCBQaGlsbGlwcw==?= | last post by:
I have read many things about this but I haven't got a clear vision on what to do if anything about this. I have a system that tries to find holes in my web site. One of the things it has...
2
1766
by: James | last post by:
What's the difference between DB2V8 32-bits and 64-bits instance on AIX? and I am confused the relationship between DB2 32/64-bits instance and 32/64-bits AIX? Maybe it is a simple question....
7
7791
by: Medvedev | last post by:
what's the meaning of the number 64 in the function fopen64?!!! i know fopen64 used to open big files but what 64 refer to and how much the usual fopen can open - pls explain
0
7051
marktang
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,...
0
6915
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...
1
6750
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
6993
tracyyun
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...
0
5353
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3003
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...
0
2993
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
567
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
193
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.