Hi
I am not one of the experts who I have been learning loads from in the
excellent posts that come through this group. However I like to
contribute as well as receive so maybe this will help spread the load.
I am also having performance problems but maybe I'm a bit further down
the line. The first thing to look at is how much memory your operating
system needs. You haven't mentioned what your operating system is but I
would imagine you are starving it of resources, most will need nearer
1GB, I would check on
http://www.microsoft.com/technet/prodtechnol/default.mspx for the
appropriate system requirements.
Then I would right click on your instance in Enterprise Manager and
choose the properties. You can then go to the memory tab and set the
maximum memory so that it leaves enough memory for the operating system.
This should improve things short term but if you can increase the memory
I would, you are probably going to face issues with only 2gb.
Good luck
Phil
This message (including any attachments) is confidential and may be
privileged. It is intended solely for the use of the individual or
entity to whom it is addressed. If you are not the intended recipient,
please e-mail the sender immediately by replying to this message and
delete the material from any computer. Armour Group plc shall not be
liable for the improper or incomplete transmission of the information
contained in this communication nor for any delay in its receipt or
damage to your system. Armour Group plc does not guarantee that the
integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference. This
message is attributed to the sender and may not necessarily reflect the
view of Armour Group plc.
-----Original Message-----
From: benbart
[mailto:mssqldba-ezmlmshield-x99906650.[Email address protected]
Sent: 30 June 2006 02:36
To: LazyDBA Discussion
Subject: SQLServer Performance ...
Hi all,
Server have 2GB of memory, at the moment, SQLServer is using 1.7GB and
the rest
is used by the OS, I presumed. Users complaining that the database seems
to be
slow. Can someone please advise where to start looking?
There is no error on the SQLSERVER LOGS. Transaction backup runs every
15
minutes, and log-shipping runs every 1 minute. These aren't my settings
so I do
not want to take control straight away without any evidence that
changing the
timings on these may lessen the load on the server somehow.
Looking at Current Activity - Process Info, does a high number Memory
Usage
means this process is using the most memory, in MB? Does the same logic
applies
for CPU and Physical IO, i.e., the higher the number, the more job or
task that
connection is doing? Are all these figures irrelevant if Wait Type is
not
waiting, Wait Time is 0 (zero) and status is sleeping? Checked the
Properties,
most of them seems to say sp_unprepare and SELECTs
Anyway, can someone please advise a good procedure on how to
troubleshoot
SQLServer Performance Issues. SQLServer version is SQLServer Enterprise
Edition
2000.
Thanks in advance.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page