sqlserver 2000 tempdb

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hubert Mayr (huma1_at_gmx.net)
Date: 05/14/04 

Date: Fri, 14 May 2004 11:07:06 +0200

Hi!

I have a sqlserver 2000 database with 84GB. That tables of that database are
daily deleted and new imported with dts (odbc) from navision.

I have 3 disks.

disk1 34 GB:
         partitions c: 10 GB free 1,8 GB
         partition d: 24 GB free 11GB
disk2 34 GB
         partition e: 34 GB free 22 GB
disk3 136 GB
         partition f: 136 GB free 18 GB

my pagefile is on partition e: 1920 MB - 3840 MB

may sqlserver tempdb properties:

size 8070 MB
available size 8069 MB

tempdb has in file group primary two filenames

filename: tempdev ---> is on c: maximal filesize limited 5568 MB
(reserved 5567)
               tempdev2 --> is on e: maximal filesize unlimited (reserved
2504)

my users are accessing to my tables with access. They read only the tables
(no updates, deletes..).

My question:

how and where (by what action) is in my case tempdb used.
how big should tempdb be? what is when it is too small?

Thanks

Relevant Pages

  • Re: Moving full-text index to a different system - problems
    ... What I did was to restore the database into a database which had the db_id I ... > The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... > The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Moving full-text index to a different system - problems
    ... different database server wuthout losing their data or full-text index. ... The Search service has loaded project. ... The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Thank you very much...again
    ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | delete..etc permissions on tempdb. ... |>database which would avoid some of this. ...
    (microsoft.public.sqlserver.security)
  • Re: Access Autonumber problem
    ... Between now and Nov. 6th 2006 you can sign up for a substantial discount. ... primary application that the database uses. ... fairly large customer base. ... In SQLServer the ID ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Importing .dat file
    ... You've obviously never written software for a bunch of clients ... It is not the primary responsibility of my users to do SQLServer. ... would stop using Excel for everything and start using a database; ... mean SQL Server Developers' edition costs $49; ...
    (microsoft.public.dotnet.languages.vb)