Is ATTAIN (with SQL Server)Cluster aware? I have read some other postings, but I have not found somebody that has it running. Is it or Is i not markus
What do you mean by cluster aware? Yes we have client who runs MS SQL 2000 on a Win2000 cluster. But this is implemented and stands for reliability, allowing cluster members to cover for a failed member. And it works, though there is short interruption on the Navision Client side, during the control transfer to another cluster member. If you mean to use it for scalability I must say that with MSSQL 2000/Navision combination it is not possible,e.g. clustering doesn’t provide a way to make two SQL servers to work together and handle mork workload. It is partly because MS SQL 2000 Server doesn’t allow easy scale out (although there ARE ways to make two or more SQL servers to share the load, though not easy and certainly not with Navision), and partly because of how Navision handles database interactions and as whole its implementation on the SQL Server. So if you meant to increase the performance, what you can do is to get more and faster hardware.