March 10, 2005 at 3:59 am
I try to install Sql Standard edition in a Hp Proliant ML570G2 2 processors xenon 2,5 GH , 2 GB ram, one array of raid 1 for data( mdf,ndf) , one array raid 1 for logs ( ldf), with W2003 ,I have only one db of Navision Financials, and all the process are very slow, I can not see any bottelnech.
i had reindex and rebuild all database index, but the problem persist
I see the process
sp_execute 29 ," " ,....
sp_execute 16 ," " ,....
tries a lot of time. (
Some idea or experience about this?
All Service pack and drivers of the machine are up to date.
March 11, 2005 at 2:07 pm
More questions than answers for starters:
10k or 15 K disks ? what size ? smart array disk controllers or the builtin ? if smart array controllers, how much memory ? what is the database size (data/log) ? how many users ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 18, 2005 at 8:10 am
At first, you should monitor disk performance with Performance monitor. Usually with Navision (which version are you running by the way?) disk performance slows down a lot. Solutions are using a fast smart array controller (128 MB cache),with 15K disks and configure RAID 0+1 instead of RAID 1. You will see immediate improvement. Secondly, Navision is very sensitive for using keys. This is to be solved by your Navision solution center.
Finally, you see the sp_execute statements in your profiler. Unfortunately, you can't see through this. Navision creates compiled queries, which are called through sp_execute. There are some performance tools available from within Navision that can reveal the actual queries. As from Navision 3.10 these are available. Your solution center can help you with this.
Regards,
Frank Verduin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply