July 8, 2022 at 6:18 am
1 default and 5 named instances on a server with 6 cpu's and 120 gb memory
SQL Server audit made the named instances inaccessible.CPU was dumping memory continously.And only after disabling the audit specification and audits were the instances and databases available.It was causing timeout errors prior to disabling.Everything got back to normal only after disabling both the actual audit and the related audit specification.How do I get audits back to working without repeating the issue.
Error
"Dispatcher (xxxxxxx) from dispatcher pool 'XE Engine main dispatcher pool' Worker xxxxxxxxx appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: xxxxxx."
July 8, 2022 at 7:21 am
This was removed by the editor as SPAM
July 8, 2022 at 12:37 pm
Are all your sql server 2016 instances upgraded up to the latest sp/cu ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 12, 2022 at 5:45 am
Yes
July 12, 2022 at 6:54 am
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 13, 2022 at 5:07 am
exactly.How do I overcome it.
July 13, 2022 at 5:37 am
Issue resolved for me. I have audits configured on my SQL Servers to write to a network share. The share had gone down, so when the server restarted, connections were timing out for whatever reason. Once the share came back up, connections could go through again.
Double check the share is valid and available to the service account !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply