When do you use SQL Profiler?

Answer Posted / vj tan

SQL Server Profiler shows how SQL Server resolves queries
internally. This allows administrators to see exactly what
Transact-SQL statements or Multi-Dimensional Expressions
are submitted to the server and how the server accesses the
database or cube to return result sets.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me in brief how sql server enhances scalability of the database system?

542


Define self join?

635


What is join and name different type of joins?

588


Explain transaction server consistency?

534


What's the information that can be stored inside a bit column?

555






Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106


What is the standby server?

528


What is CTE in SQL

549


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

88


Why I am getting this error when dropping a database in ms sql server?

602


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

549


How do you create type- insensitive operator?

574


Can we write trigger for view?

569


What is Command line parameters in PLSQL.?

588


Explain try...catch with sql server?

606