Database Allocation

Asked

Viewed 192 times

5

I have some questions regarding my database.

I use an MS-SQL "database", which is provided by Locaweb (I don’t have very clear this concept of Locaweb providing me with a "database" which has within it 3 more banks).

Well, it is divided into 3 banks:

adautil (o qual uso)
master 
tempdb

The master and tempdb, I am not allowed to edit any information.

I executed the command (which I believe returns information the size of my bank): 

EXEC sp_spaceused

I found strange the information I obtained:

database_name  |   database_size   |    unllocated space
adautil            17.00 MB             1.84 MB
master             176.06 MB            117.34 MB
tempdb             191.56 MB            187.13 MB

I don’t quite understand what that means, it just added some doubts.

Can the adautil bank fill at any time? For the free space is neither 2.00 MB.

What is the master bank for? And the tempdb bank? They are reserving space that I could be using in the adautil bank?

database sql-server
  • 1

    Utilize sp_helpdb adatina. The maximum bank size is the value maxsize. Your database grows according to usage, up to the value stipulated in maxsize.

1 answer

1


The master is the database where SQL Server stores its settings at the instance level, similar to mysql in Mysql.

The bank tempdb, as its name suggests, it is created for the temporary storage of all its banks, such as temporary tables, altered lines in transactions, among others

As @Onosendai mentioned, use the website sp_helpdb to check the maximum size of your seat.

Regarding the actual space you can use, consult your provider (in this case Locaweb). I don’t know what type of service you contracted, so you’ll have to confirm directly with Locaweb how your plan is measured (only the database, a cloud service you can manage in the background, etc).

The correct thing in my opinion is that these bases are not considered as the maximum size of your plan. These bases keep a constant size, they won’t get away from it much. The master keeps settings only and the tempdb is rebooted and cleaned when the SQL server instance is restarted, resetting its size.

More information on these bases:

http://msdn.microsoft.com/pt-br/library/ms187837.aspx

http://msdn.microsoft.com/pt-br/library/ms190768.aspx

Browser other questions tagged database sql-server

You are not signed in. Login or sign up in order to post.