Hi

We are running SQL server in a cluster environment and Hyper threading are
enabled in that servers. The application and Database servers are
different. The appliactions stores 2 MB size of acrobat files to the table
which contains more than 600000 records . We are finding some kind of
issues with this servers.

Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
that server .Is hyper threading cause any issue related to SQL Server
envirnoment.

Please reply

Regards

Swami
ganesh2012 (AT) hotmail (DOT) com

Hi

I see no reason why you should. HT processors act like there are 2
processors installed.

What issues are you having?

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Swami" <Swami (AT) discussions (DOT) microsoft.com> wrote

In general, hyperthreading is a good thing. There are some strange
behaviors on 8 or more processor clusters but these only happen under some
very specific conditions. I do find that you will need to lower the
maximium degree of parallelism to the actual physical processor count to
avoid oversaturating a system. Please reply with more details on exactly
what your symptoms are so someone here can give you a better answer.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Swami" <Swami (AT) discussions (DOT) microsoft.com> wrote

Geoff N. Hiten wrote:

Could jou post a link to some info on this?

--
Hans

Here is one I actually oberved. It is a very unusual set of circumstances
that caused the problem.

FIX: Intermittent query slowdowns and corresponding high CPU utilization
http://support.microsoft.com/default.aspx/kb/835864

Here was another fix earlier to handle some other synchronization
performance issues.

FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000
Service Pack 2
http://support.microsoft.com/default...b;en-us;818763

I am pretty sure SP2 had something in it for Hyperthreading, most likely
counting the processors correctly for licensing restrictions.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Hans de Bruin" <hans (AT) invalid (DOT) invalid> wrote