what is performance tunning in sql server ? explain.
- 1 Answers
- 3871 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer / karthikeyathirughanashamphanth
Step-1:Capturing Performance metrices.
Step-2:Find the problem Queries with Profiler.
Step-3:Define Mitigation for the Problem Queries.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the use of RDBMS?
What is sql server transaction log file?
What is the difference between views and stored procedures? Can we have input parameters for views?
Which command displays the SQL command in the SQL buffer, and then executes it?
What is the command used to recompile the stored procedure at run time?
Can you create a logon trigger in sql server 2005 express edition?
What are the differences between having and where clause.
Explain the dirty pages?
Can you explain different types of joins?
Tell me about pre-defined functions of sql?
What is database mirroring?
How we can refresh the view?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
