Home > Archive > MS SQL Server > February 2006 > QUESTION ABOUT Use Windows NT fibers OPTION









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author QUESTION ABOUT Use Windows NT fibers OPTION
Mr

2006-02-28, 8:23 pm

Hi

Why the option Use Windows NT fibers isn`t work in Windows 2003.

What can I do for use this option and use more priority with SQL server?

Using SQL 2000 in Windows 2000 is better. Why?


Please help me.

Ideas

Mr

I have SQL Server 2000 in Windows 2003 using Threads with .NET Framework 1.1

Andrew J. Kelly

2006-02-28, 8:23 pm

Fiber mode is rarely useful in most cases. Usually you need an extremely
busy system with more than 8 processors. You can get much better gains in
performance by optimizing the database and code.

--
Andrew J. Kelly SQL MVP


"Mr" <Mr@discussions.microsoft.com> wrote in message
news:0C51F85F-1709-4DDE-96EA- 0D2ADF0A5D5C@microso
ft.com...
> Hi
>
> Why the option Use Windows NT fibers isn`t work in Windows 2003.
>
> What can I do for use this option and use more priority with SQL server?
>
> Using SQL 2000 in Windows 2000 is better. Why?
>
>
> Please help me.
>
> Ideas
>
> Mr
>
> I have SQL Server 2000 in Windows 2003 using Threads with .NET Framework
> 1.1
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com