Post reply

how to make use of tempdb in sql server 2000

  • April 15, 2014 at 10:17 pm

    #150092

    how to make use of tempdb in sql server 2000

    my order by group by queries are done by Tempdb

    how to i measure this?

    say for example i am grouping a query say 2 million record on 32 bit SQL server machine how do i measure that this group by query is done at tempdb?

  • April 16, 2014 at 12:03 am

    #1706309

    Are you facing any issue related to tempdb?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 16, 2014 at 12:25 am

    #1706314

    no want to know how Tempdb is used and usage

  • April 16, 2014 at 2:35 am

    #1706346

    It's used for temp tables, table variables, sort and hash spills (which you generally don't want because they're slower than hash/sort done in memory) and for work tables which the query processor may need.

    There's not all that much monitoring of it possible in SQL 2000, the DMVs were only added in SQL 2005.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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