Some tips to use System Monitor with SQL Server 2017 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2017. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. To start System...
Tag: events
Tips for using tempdb database in SQL Server 2014
Tips for using tempdb database in SQL Server 2014 Permit the tempdb database to automatically grow. Autogrow feature is set by default. Each time the SQL Server 2014 is started, tempdb database is recreated and reset to its default size. Automatically growing results in some performance degradation, therefore you should set a reasonable size for tempdb database and a reasonable...
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...