July 23, 2008 at 6:54 pm
Hello to all. I wonder if anyone can give some light regarding setting up NT fibers in a cluster. I learned that NT fiber is an option that, in general, should not be enable unless certain things are met. Well, I just started in a new company and one cluster (the two nodes) have NT fibers enable in SQL Server.
The question is simple, do I need this for anything regarding the cluster I do not know about? Can I just disable this option for both? Your help is very much appreciated. :hehe:
July 23, 2008 at 10:27 pm
My understanding is that you should only consider using fibers if a couple conditions apply, which are:
1. You server is consistently experiencing very high work load (high CPU utilisation)
2. a microsoft engineer (or possibly an experienced partner) advises you to do this.
Using fiber mode does restrict some things that can be done (have a read of http://msdn.microsoft.com/en-us/library/aa175385(SQL.80).aspx).
From memory, changing to fiber mode will give you some additional performance but not all that much (something like 5% springs to mind). If you do end up needing fiber mode, I think that soon after this you should be giving serious consideration to getting a more powerful server.
So, if points 1 and 2 are not satisfied, you probably should consider changing the cofiguration back to normal threaded mode.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply