TempDB Database

  • how to know the limitation of number of objects(Maximum no.of objects allow tempdb database) in a tempdb database?

  • you will most likely run out of disk space long before you approach the max number of objects.

    this is the max for any database, regardless of being a user db, tempdb, or whatever.

    because object_id is an int, the most you can have is select power(2,31) -1

    objects or basically 2 billion objects.(2,147,483,647)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Lowell (12/9/2014)


    you will most likely run out of disk space long before you approach the max number of objects.

    this is the max for any database, regardless of being a user db, tempdb, or whatever.

    because object_id is an int, the most you can have is select power(2,31) -1

    objects or basically 2 billion objects.(2,147,483,647)

    That sure would make tempdb big, wouldn't it? I don't have that kind of disk space. You might have to bounce the service some time before you get there.

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

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