September 18, 2009 at 4:16 am
September 18, 2009 at 4:21 am
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]
September 18, 2009 at 4:24 am
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. 🙂
September 18, 2009 at 4:28 am
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]
September 18, 2009 at 4:32 am
September 18, 2009 at 4:42 am
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]
September 18, 2009 at 4:55 am
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
September 18, 2009 at 5:34 am
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply