data file

Question

Post reply

data file

Vishal Singh

SSCertifiable

Points: 5830
More actions
September 18, 2009 at 4:16 am

#215493

What this term mean "TempDB should have one data file for each CPU"
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

Vishal Singh (9/18/2009)
What this term mean "TempDB should have one data file for each CPU"

I would have thought someone as talented as you would know this....

It is best practise, to have one file for tempdb for each cpu.

read this

http://blogs.msdn.com/psssql/archive/2009/06/04/sql-server-tempdb-number-of-files-the-raw-truth.aspx

there are other articles that also explain it, but this one is ok.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
What this term mean "TempDB should have one data file for each CPU"
I would have thought someone as talented as you would know this....
It is best practise, to have one file for tempdb for each cpu.
read this
http://blogs.msdn.com/psssql/archive/2009/06/04/sql-server-tempdb-number-of-files-the-raw-truth.aspx
there are other articles that also explain it, but this one is ok.

I know that its a best practice but actually at one point of time I came across with somebody and the way it was written confused me a lot something like that:

data file in TempDB = #CPU :w00t:

the reason I asked this question is to make sure if there is any other term exist which I don;t know.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Silverfox SSC-Insane Points: 23150 More actions · Answer 3

Vishal Singh (9/18/2009)
Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
What this term mean "TempDB should have one data file for each CPU"
I would have thought someone as talented as you would know this....
It is best practise, to have one file for tempdb for each cpu.
read this
http://blogs.msdn.com/psssql/archive/2009/06/04/sql-server-tempdb-number-of-files-the-raw-truth.aspx
there are other articles that also explain it, but this one is ok.
I know that its a best practice but actually at one point of time I came across with somebody and the way it was written confused me a lot something like that:
data file in TempDB = #CPU :w00t:
the reason I asked this question is to make sure if there is any other term exist which I don;t know.

no worries, as long as you know what it means and that is the only term I have seen:-D

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 4

so I. but thanks for reply.

BTW did you ever come across with any situation where in A/A node the number of CPUs are not equal on both nodes?

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Silverfox SSC-Insane Points: 23150 More actions · Answer 5

Vishal Singh (9/18/2009)
so I. but thanks for reply.
BTW did you ever come across with any situation where in A/A node the number of CPUs are not equal on both nodes?

Nope but I have tended to work with only 2 node clusters, normally the servers would be identical in spec. for bigger clusters or for multiple sql instance clusters, it might be different.

I could be wrong but I have heard that windows 2008 clustering the hardware can be different, but on windows 2003, the spec has to be the same.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 6

Also remember that they all need to be the same exact size for the algorythm to work optimal.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 7

yeah , that has to be but under different environment where lets say servers has different numbers of CPUs. how exactly the TempDB configuration can impact after failover.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

data file

Cookies on SQLServerCentral