August 13, 2009 at 11:09 am
Hi,
We have a HP Proliant Server Dl380 with the following spec:
2 x Dualcore Intel 3Ghz CPUs
8GB RAM
Multipe RAID 1+0 disks, OS,Database, logs and Tempdb all on seperate disks
The OS is Windows 2003 R2 Enterprise server (32Bit)
SQL 2005 (32Bit)
I have a /PAE switch in the boot.ini file in order for the OS to seee the 8GB ram but I don't think SQL is making best use of the RAM installed. Is there something else I need to do. We are getting real performance issue here and I am sure it should be OK with this spec.
Please advise, quite desperate
Cheers
Zuma
August 13, 2009 at 11:26 am
You'll need to describe your symptoms. Plus, how you are using SQL and why you think that this has to do with SQL's use of RAM.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 13, 2009 at 12:52 pm
Hi,
thanks for the reply,
We are using Microsoft Dynamics and reporting services. We have around 35 users and the system grinds to a halt when procesing information. am I right in thinking that SQL will not use all 8GB in this scenario?
Regrads
August 13, 2009 at 3:46 pm
What kind of numbers are you seeing in perfmon on the server during those times that performance is bad?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 13, 2009 at 4:14 pm
Did you enable AWE in SQL Server? You posted this in the SQL Server 7/2000 forum - are you running 2000 or 2005 and what Edition of SQL Server are you running?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2009 at 5:02 am
Hi
Sorry it is SQL 2005 Standard Edition. I havn't ticked the AWE box, is it just a case of doing that ? will that help?
I can post the details of performace logs if needed but the memory is avg 5 MB availabilty over a working day and the disk % seems to be high.
August 14, 2009 at 9:34 am
zuma01 (8/14/2009)
HiSorry it is SQL 2005 Standard Edition. I havn't ticked the AWE box, is it just a case of doing that ? will that help?
I can post the details of performace logs if needed but the memory is avg 5 MB availabilty over a working day and the disk % seems to be high.
Yes, try enabling AWE - this is going to require that you set the lock pages in memory policy for the account running SQL Server, unless it is running as local system. If you have to set lock pages in memory, it is going to require a restart of SQL Server at least - and possibly a restart of the server.
I am assuming you meant 5GB availability - because if you are really running at 5MB of availability you are using all of the memory on the system.
You also want to set the max memory setting in SQL Server. You should set it to no more than 6GB (6144MB) for now. If you still have issue with memory and SQL Server needs more, you can then set the /3GB switch in the boot.ini and increase the max memory for SQL Server to 7GB.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2009 at 12:52 pm
Ok, thanks guys I have implemented this and put the 3GB switch in the boot.ini for good measure.
Seems to be running better but the PF usage in Task Manager is now @ 6.5GB and I thought this would drop as it was only 2.9GB before?
Is this normal????
August 14, 2009 at 2:17 pm
It is probably more soft faults and less hard faults than before.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 14, 2009 at 9:47 pm
zuma01 (8/14/2009)
Ok, thanks guys I have implemented this and put the 3GB switch in the boot.ini for good measure.Seems to be running better but the PF usage in Task Manager is now @ 6.5GB and I thought this would drop as it was only 2.9GB before?
Is this normal????
Yes, that is normal - on x86 systems Task Manager shows the AWE/PAE memory usage as PF Usage. It is not really accurate, but does give you an idea. If you really want to know how much memory SQL Server is using, you need to look at it using the memory counters in perfmon.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 1:43 am
Thanks again guys. We will see what monday morning brings and if I keep my job 🙂
Appriciate the help
November 1, 2009 at 10:00 pm
Hi, my team is using @nalitics performance tool to analyze the performance, we recommend you, it is a excellent tool, it is easy to use and the price is accessible, it fits all your needs, you can try by 15 days.
Regards
November 1, 2009 at 10:03 pm
Hi, my team is using @nalitics performance tool to analyze the performance, we recommend you, it is a excellent tool, it is easy to use and the price is accessible, it fits all your needs, you can take a whole picture about yout database performance , you can try by 15 days.
Visit
http://www.analyticsperformance.com/
Regards
November 1, 2009 at 10:08 pm
Hi, my team is using @nalitics performance tool to analyze the performance, we recommend you, it is a excellent tool, it is easy to use and the price is accessible, it fits all your needs, you can try by 15 days.
Visit
http://www.analyticsperformance.com/
Regards
November 1, 2009 at 10:09 pm
Hi, my team is using @nalitics performance tool to analyze the performance, we recommend you, it is a excellent tool, it is easy to use and the price is accessible, it fits all your needs, you can try by 15 days.
Visit
http://www.analyticsperformance.com/
Regards
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply