Tuesday, February 14, 2012

Does the number of CPU's returned

We need to configure our tempdb files according to
http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
and I need to know how many physical CPUs on each server.
thanks people.
--
-- cranfield, DBAI 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@.microsoft.com...
> We need to configure our tempdb files according to
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
> and I need to know how many physical CPUs on each server.
> thanks people.
> --
> -- cranfield, DBA|||thanks, Wayne
We've been hitting the errors as described in the below KB and I need to
rollout these tempdb changes to 150 SQL Servers. Problem is not all of them
are the same and hence the need for me to write a script that will make the
following changes to TEMPDB and batch it out to all the servers:
1) Turn off auto grow. Pre-allocate space for tempdb files.
2) Make as many tempdb files as there are CPU's (accounting for any affinity
mask settings)
3) Make these file sizes of equal amounts
So I need to know the number of physical CPUs.
Do you know if KB328551 refers to physical or logical CPUs?
thanks again
-- cranfield, DBA
"Wayne Snyder" wrote:
> 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@.microsoft.com...
> > We need to configure our tempdb files according to
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
> >
> > and I need to know how many physical CPUs on each server.
> >
> > thanks people.
> > --
> > -- cranfield, DBA
>
>|||xp_msver will tell you the number of logical processors.
MAXDOP should never be set higher than the number of actual physical
processors.
However, the issues being addressed in this KB don't apply simply to
parallel queries, the issue could easily (and more lilkley in fact...)
happen in a high volume OLTP situation where no queries may be parallel.
So, I woudl recommend configuring the number of tempdb files based on the
total number of logical processors currently in use by SQL Server.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Cranfield" <alan_cranfield@.msn.co.za> wrote in message
news:EF3824CD-EF37-4DDA-BCE4-48D9630C3C95@.microsoft.com...
> thanks, Wayne
> We've been hitting the errors as described in the below KB and I need to
> rollout these tempdb changes to 150 SQL Servers. Problem is not all of
them
> are the same and hence the need for me to write a script that will make
the
> following changes to TEMPDB and batch it out to all the servers:
> 1) Turn off auto grow. Pre-allocate space for tempdb files.
> 2) Make as many tempdb files as there are CPU's (accounting for any
affinity
> mask settings)
> 3) Make these file sizes of equal amounts
> So I need to know the number of physical CPUs.
> Do you know if KB328551 refers to physical or logical CPUs?
> thanks again
>
> --
> -- cranfield, DBA
>
> "Wayne Snyder" wrote:
> > 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@.microsoft.com...
> > > We need to configure our tempdb files according to
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
> > >
> > > and I need to know how many physical CPUs on each server.
> > >
> > > thanks people.
> > > --
> > > -- cranfield, DBA
> >
> >
> >

No comments:

Post a Comment