I've been doing a lot of reading on this and my head is starting to
hurt! It seems to be quite a feat to work out how much memory is
actually being used by our server.
I'm running W2K advanced server with SQL 2000 EE, 8GB of RAM, a min of
4GB and a max of 6GB is assigned to SQL server.
I'm trying to work out whether we've assigned enough or too
much/little memory to SQL server. My first thought was to let SQL
dymanically manage its own memory and see how much it uses, of course
when AWE (/3GB /PAE) is enabled it will just use all that is
available.
In perfmon "target server memory" = 6.1GB, "total server memory" =
6.1GB, "total pages" = 768000 ( x 8KB = 6.1GB).
My second thought was to use "total pages" - the average "free pages"
= average mem used, therefore giving me the average amount of memory
used by SQL. I found out that SQL uses a min of 4GB (the min we
assigned) and the max of all the memory, 6GB.
Is there an easier way of finding out how much memory is actually used
in this situation or is going by the above average the best way?
What i'm unsure about is will SQL just use all memory assigned to it
until it has the whole DB in memory? 20GB including indexes etc....
Any help would be greatly apprechiated. 2 11747 ti*@specialmail .co.uk (Tim Richardson) wrote in message news:<25******* *************** ****@posting.go ogle.com>... I've been doing a lot of reading on this and my head is starting to hurt! It seems to be quite a feat to work out how much memory is actually being used by our server.
I'm running W2K advanced server with SQL 2000 EE, 8GB of RAM, a min of 4GB and a max of 6GB is assigned to SQL server.
I'm trying to work out whether we've assigned enough or too much/little memory to SQL server. My first thought was to let SQL dymanically manage its own memory and see how much it uses, of course when AWE (/3GB /PAE) is enabled it will just use all that is available.
In perfmon "target server memory" = 6.1GB, "total server memory" = 6.1GB, "total pages" = 768000 ( x 8KB = 6.1GB).
My second thought was to use "total pages" - the average "free pages" = average mem used, therefore giving me the average amount of memory used by SQL. I found out that SQL uses a min of 4GB (the min we assigned) and the max of all the memory, 6GB.
Is there an easier way of finding out how much memory is actually used in this situation or is going by the above average the best way?
What i'm unsure about is will SQL just use all memory assigned to it until it has the whole DB in memory? 20GB including indexes etc....
Any help would be greatly apprechiated.
Looks like everyone is just as stumped as me!! Could really do with
some help on this one!
Tim Richardson (ti*@specialmai l.co.uk) writes: ti*@specialmail .co.uk (Tim Richardson) wrote in message
news:<25******* *************** ****@posting.go ogle.com>... I'm trying to work out whether we've assigned enough or too much/little memory to SQL server. My first thought was to let SQL dymanically manage its own memory and see how much it uses, of course when AWE (/3GB /PAE) is enabled it will just use all that is available.
In perfmon "target server memory" = 6.1GB, "total server memory" = 6.1GB, "total pages" = 768000 ( x 8KB = 6.1GB).
My second thought was to use "total pages" - the average "free pages" = average mem used, therefore giving me the average amount of memory used by SQL. I found out that SQL uses a min of 4GB (the min we assigned) and the max of all the memory, 6GB.
Is there an easier way of finding out how much memory is actually used in this situation or is going by the above average the best way?
What i'm unsure about is will SQL just use all memory assigned to it until it has the whole DB in memory? 20GB including indexes etc....
With 6MB as the max limit, it seems unlikely that SQL Server would be
able to fit 20 GB into the cache. To do that it would need at least
21 GB, with the rough assumption that you need 1 GB for the query plans
and everything else.
But I will have to admit that this is not my best game, not the least
when you bring in that much of memory. Some of my MVP colleagues know
this kind of stuff a lot better. Have you tried posting to
microsoft.publi c.sqlserver.ser ver?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: siliconmike |
last post by:
Hi, I'm looking for a reliable script that would connect to a host and
somehow determine whether an email address is valid.
since getmxrr() only gets the mx records..
Links/pointers ?
Mike
|
by: Lenard Lindstrom |
last post by:
I was wondering if anyone has suggested having Python determine
a method's kind from its first parameter. 'self' is a de facto
reserved word; 'cls' is a good indicator of a class method
( __new__ is a special case ). The closest to this I could find
was the 2002-12-04 posting 'metaclasses and static methods'
by Michele Simionato. The posting's example metaclass uses the
method's name. I present my own example of automatic method
kind...
|
by: MCollins |
last post by:
trying to determine a variable type, specifically that a variable is an
integer.
i tried using type(var) but that only seemed to produce a response in the
command line.
is there a built in python function to determine if a variable is an
integer?
|
by: Joakim Hove |
last post by:
Hello,
I have implemented a small library with a function a datatype to
manage temporary storage, and handle out correctly casted storage. The
function to get a double pointer is for instance:
double * work_get_double(work_type *work, size_t size) {}
Now, if the work area is not sufficiently large, the function fails,
|
by: Jm |
last post by:
Hi All
Is it possible to determine who is logged onto a machine from inside a
service using code in vb.net ? I have found some code that seems to work
under vb6, but doesnt under .NET ? Any help is greatly appreciated
Thanks
| |
by: CJM |
last post by:
I need to be able to determine if the user is a member of a given AD group.
I have a method of doing this, but it is not suitable for 64bit OS's, so I
need to find an alternative route. I actually think an alternative route
might actually be a better route.
I'm not an ADSI expert (frankly, I find it confusing) and I don't want to
learn any more - I just want to be able to do this one thing.
How do you guys go about achieving this?
|
by: natG |
last post by:
On a warehouse app, our Java clients constantly load/insert rows
into the db. I would like to throttle these inserts (1.5 million rows per
hr) from the Java app, based on current 'busy state' of the server.
It would be nice if I can get the server CPU utilization (and other key
factors) from db2 via jdbc. However, it needs to be low cost, since it
would likely run every x seconds.
System: db2 v 9.1 64bit on Centos 4.3 64 bit.
Thank...
|
by: Logan1337 |
last post by:
Hi, I'm wondering if anyone knows how to determine the physical size of a particular row in a table. I suppose I could figure this out manually by determining the length of all fields, but was wondering if there's a built-in way to do this.
I'm actually using SQL Server Compact, but am interested in whether it's possible on any platform.
Thanks.
P.S.
I realize there are additional things like index entries that take up space as well....
|
by: Giampaolo Rodola' |
last post by:
Hi,
I'd like to know if there's a way to determine which is the best
buffer size to use when you have to send() and recv() some data over
the network.
I have an FTP server application which, on data channel, uses 8192
bytes as buffer for both incoming and outgoing data.
Some time ago I received a report from a guy who stated that
changing the buffers from 8192 to 4096 results in a drastical speed
improvement.
I tried to make some tests...
|
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |