SQL Profiler

---

SQL Profiler interview questions

What are the tasks performed by SQL Profiler? How can you use the SQL Profiler to ensure database security? How can you reduce the amount of data collected by a trace? What is SQL Profiler? When do you use SQL Profiler? SQL Profiler - August 29, 2008 at 18:00 PM by Amit Satpute What are the tasks performed by SQL Profiler? The SQL Profiler can save traces to a file or a table. These saved traces can be used by the SQL Server Index Tuning. To be able to execute a set of actions in the future, the traces can be saved to an SQL script. The SQL Profiler can directly replay the traces. It is also possible to sort and filter the information captured. This helps in finding performance bottlenecks or deadlocks in the application. How can you use the SQL Profiler to ensure database security? SQL Profiler can audit events like Security, User Activity and DBA Activity. Security events include granting, revoking or denying permissions of a user or role. End user activity like logins and logouts can be audited.Enabling of roles for an application can also be done. How can you reduce the amount of data collected by a trace? There are various options that you need to fill up before creating a new trace. It is always a better practice to use the default options unless you dont want to get into the details of the data provided by the trace. There are a lot of events that you can audit. If you need to focus on a particular problem, then you can select the events needed and go through to determine the problem.  SQL Profiler - Dec 1, 2008 at 18:00 PM by Rajmeet Ghai What is SQL Profiler? A SQL server profile is used to capture server events of the SQL server. It helps you find out what is exactly going on in the SQL server. It is used to monitor and analyze SQL server events. It has a GUI for such activities. When do you use SQL Profiler? When some queries are performing slowly To trace and monitor events of the SQL server When indexes need to be fie tuned When security is a concern, it can be used to audit and review security activities It can be used when troubleshooting to find root cause of an issue Also read How to integrate Performance Monitor and SQL Profiler. In order to Integrate Performance Monitor and SQL Profiler, server performance needs to be captured simultaneously using both Performance Monitor’s Counter Logs and SQL Server Profiler..........  What is the purpose of SQL Profiler in SQL server? SQL Profiler captures SQL Server events from a server. The events are saved in a trace file that can be used to analyze and diagnose problem............. Define database objects. Answer - SQL Server database stores information in a two dimensional objects of rows and columns called table...... Define data, entity, domain and referential integrity. Answer - Data Integrity validates the data before getting stored in the columns of the table. SQL Server supports four type of data integrity..... Describe in brief exporting and importing utility? Answer - The Bulk Copy is a command utility that transfer SQL data to or from a data file. This utility mostly used to transfer huge data to SQL server from other database.... Write your comment - Share Knowledge and Experience