Tips for using jobs in SQL Server 2019 Consider using a centralized job server if you need to manage a large number of SQL Server jobs. Managing a large number of SQL Server jobs across a large enterprise environment can be very difficult. Centralized job server makes management easier by limiting the number of places you have to look to...
Tag: SQL Server Profiler
SQL Server 2017 Profiler Optimization Tips
SQL Server 2017 Profiler Optimization Tips SQL Server 2017 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and optimize...
Tips for using SQL Server 2014 Profiler
Tips for using SQL Server 2014 Profiler SQL Server 2014 Profiler is a graphical user interface to create and manage traces and analyze and replay trace results. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and...