We are hosting a 140 GB database on SQL Server Version 7 and Windows
2000 Advanced Server on an 8-cpu box connected to a 15K rpm RAID 5
SAN, with 4 GB of RAM (only 2 GB of which seem to be visible to the
OS) and a 4 GB swap file. (The PeopleSoft CIS application will not
permit us to upgrade to SQL 2K.) We recently upgraded the server from
4 to 8 cpus and the SAN disks from 10K to 15K drives. But we still
have heavy SAN disk usage, sometimes at 100%, and read queues often
averaging 4 and peaking at 12.
The CPUs are loaded at only 20-50%. (The politics are such that it is
easier to throw hardware at the problems.)
We are looking into archiving, converting from RAID 5 to RAID 10, and
at splitting the mdf file into several file groups in an attempt to
get more disk heads into play. (We are also looking at rewriting the
application to reduce the read volume and frequency.) Does anyone have
any other ideas?
Incidentally, does swapfile get used when the physical memory equals
the OS maximum? If the OS can only see 2 GB and we have 2 GB (actually
4 GB) of memory, is the 4GB local swap file on the C drive unused?
Thanks in advance for any assistance. 1 4354
Hi
You don't list upgrading to SQL 2000 as an option!
Your swap file should be rarely used, and you should look at the performance
monitor (which knowing the queue lengths I assume your are) and profiler to
try and locate the bottlenecks. More disks/filegroups should help, even more
disks in the raid array would help if you don't have the throughput, but you
will need to do some analysis (see book below!).
The following may be useful but are aimed at SQL 2000: http://msdn.microsoft.com/library/de...izing_5lt1.asp
You may also want to look at: http://www.sql-server-performance.com/
This is an excellent read: http://www.sql-server-performance.co...ing_review.asp
John
"Jeff Roughgarden" <jr**********@s tanfordalumni.o rg> wrote in message
news:b8******** *************** ***@posting.goo gle.com... We are hosting a 140 GB database on SQL Server Version 7 and Windows 2000 Advanced Server on an 8-cpu box connected to a 15K rpm RAID 5 SAN, with 4 GB of RAM (only 2 GB of which seem to be visible to the OS) and a 4 GB swap file. (The PeopleSoft CIS application will not permit us to upgrade to SQL 2K.) We recently upgraded the server from 4 to 8 cpus and the SAN disks from 10K to 15K drives. But we still have heavy SAN disk usage, sometimes at 100%, and read queues often averaging 4 and peaking at 12.
The CPUs are loaded at only 20-50%. (The politics are such that it is easier to throw hardware at the problems.)
We are looking into archiving, converting from RAID 5 to RAID 10, and at splitting the mdf file into several file groups in an attempt to get more disk heads into play. (We are also looking at rewriting the application to reduce the read volume and frequency.) Does anyone have any other ideas?
Incidentally, does swapfile get used when the physical memory equals the OS maximum? If the OS can only see 2 GB and we have 2 GB (actually 4 GB) of memory, is the 4GB local swap file on the C drive unused?
Thanks in advance for any assistance. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: rbt |
last post by:
Would a Python process consume more memory on a PC with lots of memory?
For example, say I have the same Python script running on two WinXP
computers that both have Python 2.4.0. One computer has 256 MB of Ram
while the other has 2 GB of Ram. On the machine with less Ram, the
process takes about 1 MB of Ram. On the machine with more Ram, it uses 9
MB of Ram.
Is this normal and expected behavior?
|
by: Felix E. Klee |
last post by:
Hi,
why does the memory consumption of the program attached below increase
steadily during execution? Shouldn't vector::reserve() allocate one
large memory chunk of memory that doesn't change anymore?
CPU: Pentium III Coppermine (Celeron)
OS: Slackware LINUX 9.1 with kernel 2.4.22
Compiler: 3.2.3
Compile command: g++ -O0 -o foo foo.cpp
|
by: Joerg Schwerdtfeger |
last post by:
Hi folks,
how can I determine the total main-memory size and the size of free
memory available in bytes?
I tried to use mallinfo() from malloc.h - resulting some strange values
in Windows (cygwin, gcc 3.3.1) and always 0 in Linux (2.4.22, gcc
3.3.2).
Thanks in advance,
|
by: Douglas |
last post by:
Hi,
Any suggestions for estimating the amount of memory a program will
use in advance, before it is run. Rules of thumb etc.?
Is it then possible to warn a user that a program is likely to crash
at start up? Swap space issues etc.......
Douglas
|
by: Gawain Lavers |
last post by:
I have a script which uses a lot of object augmentation (in order to
extend the functionality of DOM elements), and I'm clearly stressing
out my browser (I rapidly get to a point where Firefox is telling me
that the script is "unresponsive", often more than once. I'm not sure
if it's simply execution time or memory usage.
My question is this: if I augment an object thusly:
function TestAug() {
this.fun = function() {
| |
by: hamishd |
last post by:
Hello,
In my application I create some large vectors to hold data. For
example:
std::vector<DataItemClass*MyData;
DataItemClass * DataItem;
for(i=0;i<SomeLargeLimit;i++){
DataItem = new DataltemClass;
|
by: Tony |
last post by:
Hi expert,
I installed DB2 v8.2 server on Solaris 9 box. When I connect to DB2
using control centre or other applications(except command line),
around 12 db2sysc processes pop up and each one consumes more than 2G
memory(total 30G memory). The server only has 8G physical memory, so
DB2 costs too many memory resources. I tried to reduce the
appgroup_mem_sz and app_ctl_heap_sz, but it didn't work. What else can
I do?
|
by: frederic.pica |
last post by:
Greets,
I've some troubles getting my memory freed by python, how can I force
it to release the memory ?
I've tried del and gc.collect() with no success.
Here is a code sample, parsing an XML file under linux python 2.4
(same problem with windows 2.5, tried with the first example) :
#Python interpreter memory usage : 1.1 Mb private, 1.4 Mb shared
#Using http://www.pixelbeat.org/scripts/ps_mem.py to get memory
information
|
by: Daniel Peterson |
last post by:
I'm responsible for a pair of IIS 6 webservers that run our production
ASP.Net application. We push code on a monthly basis, and about two weeks
after our October code push, we started to run into occasional webserver
errors.
The application pool is configured to run as a domain user which has
permissions to the web code. When we have issues, the webserver will return
the ASP.Net "Server Application Unavailable" page, and our app pool...
|
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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |