Post reply

SLEEP_BPOOL_STEAL wait type

  • June 22, 2021 at 8:50 pm

    #3899449

    Does anyone know what the wait type SLEEP_BPOOL_STEAL means?  I cannot find any documentation for it.

    We are trying to troubleshoot very long runtimes in one of our test environments.  I am seeing a lot of SLEEP_BPOOL_FLUSH - which I am familiar with - but I am also seeing SLEEP_BPOOL_STEAL - which I cannot find any additional information on.  These are mainly happening on log shipping restores.

    Server is running SQL 2019 CU10

    We are fairly certain the issue is related to storage array on the host server, but are trying to gather as much information as we can since the problem doesn't seem consistent.

  • June 23, 2021 at 6:24 am

    #3899542

    looks like you need to learn to google. first hit when searching for it https://www.sqlskills.com/help/waits/sleep_bpool_flush/

  • June 23, 2021 at 12:44 pm

    #3899644

    I guess I could come back with "Looks like you need to learn to read." but that would be rude.

    I was not asking about SLEEP_BPOOL_FLUSH - I can find plenty of information on that.

    I am looking for information on SLEEP_BPOOL_STEAL

     

     

  • June 23, 2021 at 4:37 pm

    #3899756

    double apologies - way to many here that just expect us to supply them with the links - and I misread your title and didn't confirm the contents.

    Unless Paul sees this thread I would send him an email and ask about it - I'm sure that if it is important it will be added to the list he maintains - https://www.sqlskills.com/help/waits/

    its likely to be a new one on 2019 as I never saw that one before (at least like that - I did see Buffer::Steal which may or not be the same)

     

  • June 23, 2021 at 5:58 pm

    #3899785

    No hard feelings...  been a frustrating week 😀

    Thanks for that link; that's a great list.

  • October 1, 2021 at 10:23 pm

    #3935714

    It is indeed a brand-new wait type that was added in a recent 2019 CU. I just added it to the waits library - see https://www.sqlskills.com/help/waits/sleep_bpool_steal/ for details. Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply