Very slow NAV 5.0 with SQL2005

SBN

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

kine

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...

SBN

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

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?

davmac1

How many users?
Any terminal servers?

SBN

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

Thank you for your big number of replies,
Please one by one that I can understand you.
=D>

davmac1

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.