MS SQL Server - Re: Does the number of CPU's returned by xp

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

Re: Does the number of CPU's returned by xp_msver include Hyper-Thread

Wayne Snyder

2005-07-05, 7:23 am

I beleive that hyper threaded installs DO show the hyper CPUs , so you will
see double the CPUs..... You also may wish to reduce the number of CPUs that
sql can use and/or reduce the MAXDOP setting.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"Cranfield" <alan_cranfield@msn.co.za> wrote in message
news:3C283647-380D-4A91-A3BB- 5B4956044691@microso
ft.com...
> We need to configure our tempdb files according to
> http://support.microsoft.com/defaul...kb;en-us;328551
>
> and I need to know how many physical CPUs on each server.
>
> thanks people.
> --
> -- cranfield, DBA

Sponsored Links