Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-10-26 : 21:51:58
|
| Hi,We used Navision 5.0 and SQL Server SE 32 Bit in daily operation. If not in the peak hours, everybody happy the performance. During peak hours, the performance looks bad.It's possible to apply Network Load Balancing to this Navision Application Server, and SQL Server 2005 SE 32 Bit |
|
|
pphillips001
Starting Member
23 Posts |
Posted - 2010-11-01 : 12:52:01
|
| There are loads of factors to consider. A likely culprit are the same queries fighting over the same resource.I would personally keep an eye on the slowest running queries and make sure all indexing is in place to maximise performance.Make sure statistics are up-to-date and optimised accordingly.Oh - check you isolation level as well. Optimistic locking on SQL 2005 caught me out once - changing it to snapshot made the system fly.===========================There is no reality - only perspective. |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-11-03 : 07:16:59
|
| tq sir |
|
|
|
|
|
|
Navision 5.0 and SQL Server 2005 SE 32 Bit