AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sql on mac server3/7/2023 ![]() When first learning about DAC, you will quickly see that it is enabled by default, however, it is only for connections that are originating from the local system. With the DAC you are now able to find the long-running query and kill that session or troubleshoot the issue. In my experience, this has been related to long-running queries that are not optimized for data the end user wants to return or your SQL Server not allowing new connections. Typically, what ends up happening and where it can help is when your SQL Server is screaming for resources, but there are none are available. While it does reserve a connection for you, it is only one thread, there is no parallelism happening here, in fact, you will receive an error. This works by telling SQL Server to reserve a thread specifically for processing your queries in an emergency. This was built to help you connect to SQL Server and run basic queries in cases with critical performance problems. The dedicated admin connection (DAC) can help you out of a sticky situation.
0 Comments
Read More
Leave a Reply. |