Allocation Database

Question

Allocation Database

Navigation

#1 by (1 votes)

5

I have some doubts about my database.

I use a "MS-SQL" database, which is provided by LocaWeb (I do not have very clear this concept of LocaWeb giving me a "bank" which has 3 more banks in it).

Well, it's divided into 3 banks:

adautil (o qual uso)
master 
tempdb

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

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

EXEC sp_spaceused

I found the information I got strange:

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 did not quite understand what that meant, just added some doubts.

Can the nursing seat fill up at any time? Because the free space is neither 2.00 MB.

What is the master bank for? And the tempdb bench? Are they reserving space that I could be using in the adautil bank?

sql-server

asked by anonymous 15.08.2014 / 17:14

1 answer

Increment input values in +1 containing letters and numbers using JQuery? Mount array with txt data

score 1 · Accepted Answer

master is the database where SQL Server stores its instance-level settings, similar to mysql in MySQL.

The tempdb bank, as its name implies, is created for temporary storage of all your banks, such as temporary tables, changed rows in transactions, etc.

As @OnoSendai mentioned, use the procedure sp_helpdb to check the maximum size of your bank.

Regarding the actual space you can use, check with your provider (in this case, Locaweb). I do not know the type of service contracted, so you will have to confirm directly with Locaweb how your plan is measured (only the database, a cloud service that you can manage in the background, etc).

The correct thing is that these bases are not considered the maximum size of your plan. These bases maintain a constant size, they will not get away much of it. The master stores the settings only and tempdb is reset and cleared when the instance in the SQL server is restarted, zeroing its size.

More information on these bases:

link