Lesson 10
SQL Server Profiler Conclusion
In this module, you learned how to use SQL Server Profiler to help identify problems with SQL Server. Now you should be able to:
- Identify the key features of SQL Server Profiler
- Create a trace
- Identify the events that SQL Server Profiler can track
- Identify the information that can be traced
- Run a trace
- Replay a trace
- Use the Index Tuning Wizard
- Use the Trace Wizard
The following terms were introduced to you in this module:
Glossary Terms
- Event:A significant occurrence
- Event category:A group of events
- Event class:A group of events
- Filter:Limits what is viewed
- Trace:The information that SQL Server profiler gathers
- Index Tuning Wizard:A wizard that helps you develop the correct indexes .for a table
- Trace Wizard:A SQL Server wizard that helps you set up a trace
In the next module you will learn how to monitor SQL Sever with various operating system tools.
The "SQL Server Profiler" utility has been deprecated in SQL-Server.
Microsoft has introduced Extended Events as a successor technology to replace SQL Server Profiler ¹ ². Extended Events offers several advantages, including a built-in GUI and potentially better performance. It can audit a wide range of actions, but it suffers from some deficiencies, such as not being able to provide information on what was deleted or inserted. Also, there is no means for before-and-after auditing to compare new and old values for updates.
SQL Server Profiler -Exercise