data file

  • 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]

  • 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]

  • 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]

  • 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]

  • 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]

  • 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]

  • 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

  • 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]

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

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