mibuso.com
Home› Navision Attain

MS SQL Server tweaks

KRISHNAKRISHNA Member Posts: 11
edited 2004-01-15 in Navision Attain
Are there any SQL server tweaks like
Minimum memory
SQL server priority over all other applications
Swap file
Cache size
etc.
Thanks,
KRISHNA DAS

Comments

  • SypherSypher Member Posts: 4
    Of course there is!
    you must use the Entreprise manager(if you got the MSDE you Need to intall the client 's app with the Real SQL server CD)...connect to your server and right click your server name, and you got the properties right there :shock:
    ...have fun
  • KRISHNAKRISHNA Member Posts: 11
    The first day we went live switching from native Navision to SQL we had lots of problems. The clients kept freezing up and some sales order took up to 15 minutes to post when usually it took seconds. Also many clients could not log in.
    This was so despite the fact that we had a new dual 3 ghz zeon processors with 8 data drives in a mirrored raid 0+1. (4gig ram)
    It turned out that I had to disable the licensing service and up the size of the swap file from 2 Gigs to 6 gigs. That changed the performance the most.
    Plus I set up the SQL Server to have a minimun RAM memory and upped the priority of SQL Server.
    Now I am thinking of unistalling IIS from the machine since it is used solely for Navision/SQL. That should help.
    Also looking to switch off other services that are not absolutely needed.
    Another suggestion was to add drives to the server and put the swap file and the sql backup logs on drives not on the boot drive or data drives.
    Any suggestions are appreciated.
    KRISHNA DAS
  • mandykmandyk Member Posts: 57
    Please seek out Navision troubleshooting tools-kit that come up with extended client monitor fob to scan all your codes and will give you exact elapsed time per statement. There is a documentation in how to troubleshoot the performance issue included in that kits as well.
    From my experiences, even with super doom server with codes not yet being optimized, it will not help in performance.

    My customer is 8 zeon P 3 processors , 4 gigz of memory, cluster environemnt with couples raids 0+1 san disks. during the time my codes wasn't optimize, still won't feel like super servers ;), specially if you have more than 30++ concurrent users. it is like pc xt installed with Navision..
    :)

    Apart from Navision tool, you can try to use Performance Monitor,
    please go this url: http://sql-server-performance.com/
    Sure you will get all your answer around SQL server.
    have fun!
  • KRISHNAKRISHNA Member Posts: 11
    I will get my hands on that tools kit and read the instructions. But how does one tune up SQL from Navision. I thought that was imposible...
    KRISHNA DAS
  • SypherSypher Member Posts: 4
    Try the client monitor thing from mandyk, unfortunatly I'm new to Navision but I have 2 exp with SQL server and the system you described is top of the line, and if you configured a few things right, it should run really really fast.

    there's a tools with SQL called Profiler that monitor EVERY things that goes on in SQL(like how much time a query run, how much people there is)

    And don't forget locking which is VERY different in SQL!
    (I think Navision code is SQL friendly but if YOU developped code and didn't write with SQL in mind..maybe that's one solution to your trouble)
Sign In or Register to comment.