No. however, we recommend keeping the number of databases created in one single TencentDB for SQL Server instance below 70 for the better performance. If you need more databases, please submit a ticket.
When Tencent Cloud creates each SQL Server database, it automatically allocates 500 MB of initial capacity to which the data will be written first when any data is written at all.
Therefore, even if you write no or only a very small amount of data, storage monitor will also display 500 MB.
After the data is deleted from SQL Server, the extended data files don't shrink, and the free capacity inside the files can support subsequent operations such as insertion and update.
For example, if you apply for an instance of 50 GB and write 50 GB of data to a database and then delete all the data, the system monitor will show that you have used up the 50 GB of capacity. However, you can still continue to write a lot of files.
Please change the authentication method to "SQL Server Authentication".
For data security considerations, TencentDB for SQL Server currently doesn't support public IP. If you need to use a public IP, you can use the port mapping function of SSH2 to connect to, configure and manage an instance from the internet. For detailed directions, see Connecting to an Instance.
Was this page helpful?