When do you use SQL Profiler?

Answers were Sorted based on User's Feedback



When do you use SQL Profiler?..

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

When do you use SQL Profiler?..

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

When do you use SQL Profiler?..

Answer / seyed riswan

Profiler help us to view the changes happened in the back
end process.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL Server Interview Questions

How do SQL server 2000 and XML linked?

2 Answers  


what is denormalization and when would you go for it? : Sql server database administration

0 Answers  


What is the difference between varchar and nvarchar types?

1 Answers  


what is blocking? : Sql server database administration

0 Answers  


Which table keeps the locking information?

0 Answers  






How to enable/disable indexes?

0 Answers  


What happens if you add a new index to large table?

0 Answers  


System variable and temporary variables

0 Answers   Wipro,


One table how may column and Primary key

3 Answers  


What is the impact on other user sessions when creating indexes?

0 Answers  


one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  


What is the difference between set and select?

0 Answers  


Categories