Share via

Will SQL Server 2014 tempdb data file growth to 100G cause session congestion

跃 梁 0 Reputation points
2023-12-21T06:11:53.6033333+00:00

Will SQL Server 2014 tempdb data file growth to 100G cause session congestion？

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 46,861 Reputation points
    2023-12-21T06:46:41.1966667+00:00

    Your post is a bit unclear.

    DB growth always cause I/O traffic and will slow down the system, not only single sessions.

    0 comments
  2. Anonymous
    2023-12-22T02:23:46.33+00:00

    Hi @跃 梁

    Tempdb data file growth can cause session congestion if the disk space is insufficient or the file size is not properly configured.

    You can use sys.dm_db_session_space_usage or to monitor usage.

    If you need more targeted advice, you need to provide more details.

    Best regards,

    Percy Tang

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.