Interested to Buy Any Domain ? << Click Here >> for more details...
What is SQL Profiler what is the use of it?
- 2 Answers
- 13437 Views
- 247Customer, Steria, I also Faced
- E-Mail Answers
Answer Posted / rathi
SQL profiler is a graphical tool that allows system
administrator to monitor in an instance of the SQL Server.
Use of SQL Profiler:
• Monitor the performance of an instance of SQL
Server.
• Debug Transact-SQL statements and stored procedures.
• Identify slow-executing queries.
• Test 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.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
what do you understand by change data capture?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Difference between report and query parameter. Why do we need different type of parameter?
How to insert new line characters into strings?
How to list all field names in the result set using mssql_field_name()?
What is the difference between Clustered and Non-Clustered Index?
Mention the command used to rename the database.
Difference between 2NF &3NF ?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What are sql servers used for?
how will add additional conditions in sql?
Explain what role entity and relationship play in an ER diagram.
What is the correct order of the logical query processing phases?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How do you use a subquery to find records that exist in one table and do not exist in another?
