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 |
Can a database be shrunk with users active?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How to execute multiple stored procedures at one time in sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are various ways to enhance the ssrs report?
What is master database? : SQL Server Architecture
How to get a list all databases on the sql server?
What are different types of join?
What are the system database in sql server 2005?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What do you mean by authentication modes in sql server?
What are pages and extents? : SQL Server Architecture
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)