APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse
![]() -->
Microsoft SQL Server provides a comprehensive set of tools for monitoring events in SQL Server and for tuning the physical database design. The choice of tool depends on the type of monitoring or tuning to be done and the particular events to be monitored.
These time-saving free tools cover database design, database performance monitoring, database integrity protection, and database management. DESIGN Databases. SQL Data Profiler. Manage SQL Server and Azure SQL Database with 147 sample PowerShell scripts. It also supports SQL Server 2016 and 2017, and Windows Server 2016. ApexSQL offers the most comprehensive set of SQL Server DBA and Developer tools, with a broad array of award-winning tools, backend by killer support.
Following are the SQL Server monitoring and tuning tools:
Choosing a Monitoring Tool
The choice of a monitoring tool depends on the event or activity to be monitored.
1 Using SQL Server Management Studio XEvent Profiler
2 Using SQL Server Profiler system stored procedures. Windows Monitoring Tools
Windows operating systems and Windows Server 2003 also provide these monitoring tools.
For more information about Windows operating systems or Windows Server tools, see the Windows documentation.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |