Very slow NAV 5.0 with SQL2005

SBN
SBN Member Posts: 26
edited 2009-09-18 in SQL Performance
Hello,
I'am working with Dynamics Nav 5.0 with SQL Server 2005,it's going very slow with a lot of Lock error!!! :-k
For more information about our System:
Hard:
Intel Xeon Quad 2,5GH
6GB RAM
Network 100MB of speed
3 logic partition of HD 400GB
Soft:
Widows server 2003 R2

Our DB has:
Used Space:94,2GB
Reserved Space:104,2GB
Object cache:3,2GB
Thanks in advance

Comments

  • kine
    kine Member Posts: 12,562
    64bit or 32bit? (I assume 64bit OS and SQL)
    3 logic partition of HD 400GB

    That's problem for such a big database... logic partitions are not good, and only one HDD is not good too...

    You need one HDD for Temp table, one for Transaction log and one for NAV DB as minimum... BUT NOT LOGICAL DISC! It must be physical discs...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • SBN
    SBN Member Posts: 26
    Hi kine,
    Our sever have 32bits SQL and Windows,and about discs we have 3 physical : one for DB files,the second for LOG file and the third for the OS.
    What about this config?
  • kine
    kine Member Posts: 12,562
    If you have 32bit system and SQL, than 6GB of RAM is waste... ;-)
    3 logic partition of HD 400GB
    and about discs we have 3 physical : one for DB files,the second for LOG file and the third for the OS.

    What is true?

    Are the HDDs in some RAID?

    What about network?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • davmac1
    davmac1 Member Posts: 1,283
    How many users?
    Any terminal servers?
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • SBN
    SBN Member Posts: 26
    Hello,
    For Kine:
    1:I'am sorry ,We have realy 3 physical HDs, after a small verification I conclude this.
    2:How can I verify that discs are ih the same RAID or not?
    3:About network we have 100MB of speed.

    For davmac1:
    1:We have a licence of 30 users but realy there are only 20 users connected to the DB.
    2:About terminal servers ,we have 7 users connected to the server with VPN.

    Thank you for Help
  • SBN
    SBN Member Posts: 26
    Thank you for your big number of replies,
    Please one by one that I can understand you.
    =D>
  • davmac1
    davmac1 Member Posts: 1,283
    Sometimes you just need some paid professional help.
    Based on the vagueness and high level general nature of your questions, I recommend you find some qualified professional who can help your organization.
    There are contributors in this forum who specialize in these services who are extrememly competent.
    I recommend you engage one of them and ask them for a quote for services.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/

Categories