December 9, 2014 at 6:01 am
how to know the limitation of number of objects(Maximum no.of objects allow tempdb database) in a tempdb database?
December 9, 2014 at 6:45 am
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
December 9, 2014 at 7:27 am
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