I'm new to SQL server I'm trying to figure out if there is anyway we can set max disk timeout? If not then where SQL server picks the disk time out values?

Yatindra Vaishnav 21 Reputation points
2021-03-08T20:39:41.46+00:00

I see MSSQL Server event ID 833 which is BUF_LONG_IO and indicating that SQL Server sees the IOs taking 15Seconds (ref: https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-833-database-engine-error?view=sql-server-ver15 ). And then I see the event ID 845 which idicate that the which is BUFLATCH_TIMEOUT (reference :
https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-845-database-engine-error?view=sql-server-ver15)

I appreciate the replies in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-03-09T03:17:20.283+00:00

    Hi @Yatindra Vaishnav ,

    Unfortunately, there is no way to change SQL Server picks the disk timeout values. We can change some timeout values for remote login or query for current server, please refer to sp_configure (Transact-SQL). Hope it well help your learning.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Yatindra Vaishnav 21 Reputation points
    2021-03-09T05:52:16.95+00:00

    Thanks Tom and Carrin, for your answers I'm developing my disk driver and that is where I'm getting these event logs.

    0 comments No comments