February 27, 2010 at 11:30 pm
Dear Experts,
We have a sql server 2005 and Ms Navison (ERP) system
Informations:
Server Hp OS= spwindows 2003 server service pack 3,
Sql server 2005
ERP navision erp
from begining it was going fine, now db size is 250 gb..
so we have upgraded the RAM 8gb to 16 gb but there is no performance changes
So please advice to me, after upgrading the RAM what changes we have to follow in sql server 2005? or any other ideas to increase the performance of server?
Here i tried some configurtions nothing is happening..like db optimize, index,shrink etc...
March 2, 2010 at 4:52 am
plz mention sql server edition and service pack info.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
March 2, 2010 at 5:44 am
SQL will run smoothly for 250 GB of data on 8 GB RAM depending your application and load.
First of all let me tell you that it's not always correct that adding RAM will improve the performance.
You need to find out the before adding RAM that what is the actual problem. There could be many issues like CPU, I/O, Network, stored procedures, indexing, triggers etc...
Still you can do the same exercise and Take help of performance monitor and SQL Profiler to narrow down the problem.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2010 at 7:48 am
There are a kajillion things that could be at issue here, and I bet there are many things at play causing problems. Just a quick list: missing indexes, suboptimal IO configuration, too little CPU power, sql server configurations, OS file fragmentation, internal database fragmentation, improper/no maintenance, out of date statistics, shrinking database, etc,etc
I HIGHLY recommend you get a performance tuning expert to give your system a review and mentor you on how to evaluate performance in the future.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 3, 2010 at 8:18 am
Saravanan_tvr (2/27/2010)
Here i tried some configurtions nothing is happening..like db optimize, index,shrink etc...
Navision has it's on "internal" indexes that it uses as well so you might need to do some maintenance jobs within Navision if they are not already.
I am in agreement with SQLGuru...Navision is a complex software that you might want to get an expert with Navision optimization expereince. There a ton of people out there that work with Navision (or Microsoft Dynamics as it is called now).
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 3, 2010 at 12:25 pm
I saw no mention of disk configuration in your original post. How many and what kind of drives do you have your database spread over? Also how does the disk IO look when you run Perfmon on the machine. These are basic things to look at and start looking into best practices on.....
John.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply