Share via

SQL SERVER latency issue

kedar giri 61 Reputation points
2024-04-30T12:08:06.27+00:00

we have created VM and install SQL Server on it, VM have Ephemeral disk which is 64 GB. Ephemeral Disk have tempdb on it. the Ephemeral disk size is not enough. so Is there any possibility of way to increase the size of Ephemeral disk?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,850 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Umar 160 Reputation points
    2024-04-30T12:10:47.5266667+00:00

    Subject: Re: SQL SERVER Latency Issue

    Dear Kedar Giri,

    Thank you for reaching out to us with your question about increasing the size of the Ephemeral disk on your SQL Server virtual machine (VM).

    I am Umar, a member of the Support Team, and I am happy to help you with your inquiry. Ephemeral disks, also known as temporary disks, provide short-term storage for a VM. The size of an Ephemeral disk is determined at the time of VM creation and cannot be increased later.

    However, there are a few possible workarounds to address the issue of insufficient Ephemeral disk space for your SQL Server tempdb:

    1. Add additional data disks to the VM: You can add one or more data disks to your VM to provide additional storage. You can then move the tempdb to one of the data disks or stripe it across multiple data disks for better performance.
    2. Modify the tempdb configuration: You can consider adjusting the tempdb configuration to reduce its size or the rate at which it grows. For example, you could reduce the number of user objects that are created in tempdb or use the Resource Governor to limit the amount of memory and CPU that are available to queries that use tempdb.
    3. Use Azure SQL Database or Azure SQL Managed Instance: If you are open to exploring other options, you could consider using Azure SQL Database or Azure SQL Managed Instance, which are fully-managed Platform-as-a-Service (PaaS) offerings that provide built-in high availability, automatic backups, and automatic patching. These services also handle tempdb management for you, so you do not need to worry about provisioning or managing storage for tempdb.

    I hope you find this information helpful. If you have any further questions or need additional assistance, please do not hesitate to ask.

    Best regards,

    Umar

    0 comments
  2. CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor
    2024-05-02T05:36:34.4733333+00:00

    Hi @kedar giri

    Is there any possibility of way to increase the size of Ephemeral disk?

    No, as answered above, once the ephemeral disk is configured, the disk cannot be resized. So, you might need to recreate the VM with a larger size.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments