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 |
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Define primary key?
How do I open port 1433?
Do you know what are different types of replication in sql server?
How does recursive cte works in sql server?
How to execute a sql statement using mssql_query()?
What is difference between oltp and olap?
What is query and its types?
What is normalization? Explain different forms of normalization?
how many non clustered index in sql server 2008,2010,2012
How do I run sql server 2014?
What is auditing in sql server?
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)