SQL Server is a relational database management system (RDBMS) from Microsoft that’s designed for the enterprise environment.
- SQL Server runs on T-SQL (Transact -SQL), a set of programming extension s from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling , row processing, and declared variables.
- It is a full-featured databse primarily designed to compete against competitors Oracle Database (DB) and MySQL. SQL Server is sometimes referred to as MSSQL and Microsoft SQL Server.
SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. Your use of SQL Server Profiler depends on the reason you are monitoring an instance of the SQL Server Database Engine. For example, if you are in the development phase of the production cycle, you are not as concerned about the overhead incurred by tracing many events as you are concerned about obtaining all the performance details you can gather. If, by contrast, you are monitoring a production server, you want your traces to be more focused and limited in time so tracing incurs the least load on your server.
- Monitor the performance of an instance of theSQL Server Database Engine, Analysis Server, or Integration Services (after they have occurred).
- Debug Transact-SQL statements and stored procedures.
- Analyze performance by identifying slowly executing queries.
- Perform stress testing and quality assurance by replaying traces, Replay traces of one or more users.
- Perform query analysis by saving Showplan results, Test Transact-SQL statements and stored procedures in the development phase of a project by single-stepping through statements to confirm that the code works as expected.
- Troubleshoot problems in SQL Server by capturing events on a production system and replaying them on a test system. This is useful for testing or debugging purposes and allows users to continue using the production system without interference.
- Audit and review activity that occurred on an instance of SQL Server. This allows a security administrator to review any of the auditing events, including the success and failure of a login attempt and the success and failure of permissions in accessing statements and objects.