Events Archives - {coding}Sight https://codingsight.com/category/database-development/events/ Blog for SQL Server DBAs and Developers Thu, 23 Sep 2021 09:44:05 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Events Archives - {coding}Sight https://codingsight.com/category/database-development/events/ 32 32 How To Create SQL Trace To Capture SQL Server Events https://codingsight.com/how-to-create-a-sql-trace-to-capture-sql-server-events/ Wed, 21 Oct 2020 15:43:35 +0000 https://codingsight.com/?p=10353 Facing an SQL Server performance issue, you need to identify the source of that performance problem fast. Therefore, a tool for tracking the current workload and detecting the bottleneck issues without causing extra load is necessary. SQL Server provides various tools to collect the SQL Server events. For instance: The SQL Trace tool, introduced in …

The post How To Create SQL Trace To Capture SQL Server Events appeared first on {coding}Sight.

]]> How to Capture and Analyze SQL Server Events https://codingsight.com/how-to-capture-and-analyze-sql-server-events/ Fri, 15 Nov 2019 00:01:41 +0000 https://codingsight.com/?p=8123 When working as a SQL Server database administrator, you should have the skills to dive deeply into the ocean of the SQL Server Engine and find what is happening internally, in order to be able to detect, troubleshoot and fix any problem that you may face. You can take benefits from the logs that are …

The post How to Capture and Analyze SQL Server Events appeared first on {coding}Sight.

]]> Events and Threads in .NET https://codingsight.com/events-and-threads-net/ Wed, 02 Aug 2017 14:19:44 +0000 http://codingsight.com/?p=1969 I’d like to tell you straight off that this article will concern not threads in particular, but events in the context of threads in .NET.  So, I won’t try arranging threads correctly (with all blocks, callbacks, canceling, etc.) There are many articles on this subject. All examples are written in C# for the framework version …

The post Events and Threads in .NET appeared first on {coding}Sight.

]]> Extended Events for SSAS https://codingsight.com/extended-events-for-ssas/ Fri, 10 Mar 2017 12:49:20 +0000 http://codingsight.com/?p=707 Cubes require frequent monitoring since their productivity decreases quite often (slowdowns during query building, processing time increment). To find out the reason of decrease, we need to monitor our system. For this, we use SQL Server Profiler. However, Microsoft is planning to exclude this SQL tracing tool in subsequent versions. The main disadvantage of the …

The post Extended Events for SSAS appeared first on {coding}Sight.

]]>