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 |
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Explain what are the restrictions while creating batches in sql server?
Define inner join in sql server joins?
What are the parts of a function?
How to change location of errorlog in SQL?
What structure can you implement for the database to speed up table reads?
How many databases instances are there in sql server 2000?
How do I list the available tables in a database I'm querying?
when we use function instead of procedure? plz tell me the situation with ex?
Explain syntax for dropping triggers?
hi i gone though satyam interview. what is Acid Properties?
Can you force a query to use a specific index?
Oracle (3253)
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)