We got a new customer service request where they got the following error message: The database 'UserDB' has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.
We found that database reached it's size limit (1024GB) with Space Used 1023.253 GB. After analyzing these two links Lesson Learned #150: Calculating the space used by table and per column - Microsoft Community Hub and Lesson Learned #227: How much data is using my database per table - Microsoft Community Hub and we didn't find that might be related with PVS, so, the immediate option is to increase the SLO to give you more available space
Alternatively other options might be:
Some longer term mitigations that might be worth considering:
The data compression feature help's to reduce the size of the database. In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.