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 local temp table?
How to convert numeric expression data types using the cast() function?
What are the four main query statements?
Can we insert data if clustered index is disabled?
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
What do we have to check in database testing?
how to control the amount of free space in your index pages? : Sql server database administration
Can sql servers link to other servers?
Can we use custom code in ssrs?
How to update existing rows in a table?
What is difference between foreign key and unique key?
Explain the types of indexes.