what is performance tunning in sql server ? explain.
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 |
How to change a login name in ms sql server?
How to read data in a table with "select" statements?
Explain the different types of joins?
How to change the system date and time from SQL Plus Terminal ?
What is stored procedures?
Why union all is faster than union?
What is the purpose of indexing?
Why functions are used in sql server?
Why are you getting errors when creating a new odbc dsn?
what's sql server? : Sql server database administration
What is indexed views? plz explain with example?
What happens if you delete a table that is used by a view?
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)