When do you use SQL Profiler?
Answers were Sorted based on User's Feedback
Answer / guest
SQL Profiler utility allows us to basically track
connections to the SQL Server and also determine activities
such as which SQL Scripts are running, failed jobs etc..
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / seyed riswan
Profiler help us to view the changes happened in the back
end process.
Is This Answer Correct ? | 1 Yes | 3 No |
What is the stuff?
What is the use of @@spid?
What is log in sql server?
What is indexing in sql server with example?
explain different levels of normalization? : Sql server database administration
How to generate create function script on an existing function?
What command do we use to rename a db, a table and a column?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
Is truncate a dml command?
What is an expensive query?
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
Can an entity have two primary keys?