Post reply

stop responding to queries of specific database

  • April 26, 2021 at 4:40 pm

    #3875936

    Version & Edition of SQL? 2019/2017/2016? express/standard/enterprise?

    tried things like sp_whoisactive to see what’s going on?

    Are you hitting max worker threads.

  • April 28, 2021 at 6:32 am

    #3876700

    thanks.

    it's a 2019 enterprise edition

    the server has about 32 gb of ram , 8 cores of cpu , and server load is normal always .

    how can I see that I'm hitting the max worker threads or not ?

  • April 28, 2021 at 8:59 am

    #3876765

    Max memory / min memory settings? 32GB of RAM max memory should be around 25GB to SQL, if the value from below is 2147483647 you need to go and change your memory settings to 25600

    select * from sys.configurations where name = 'max server memory (MB)'

    Workers in use at the moment use below

    SELECT max_workers_count FROM sys.dm_os_sys_info

     

    For 8 cores you should have the config set to 0 or 576 (usually leave it 0 as you want the OS to manage it, verify using

    select * from sys.configurations where name = 'max worker threads'

  • April 28, 2021 at 9:57 am

    #3876782

    so based on the output , it's ok on this side

    what else you think could cause a problem ?

    Attachments:
    You must be logged in to view attached files.

  • April 28, 2021 at 10:33 am

    #3876798

    Memory configuration

    Poorly written queries

    Memory leaks

    To much happening on the server for it to respond

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

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