Step-1:Capturing Performance metrices. Step-2:Find the problem Queries wit

what is performance tunning in sql server ? explain.

Question Posted / karthikeyathirughanashamphanth

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the information that can be stored inside a bit column? : Sql server database administration

1006

Can we write a distributed query and get some data which is located on other server and oracle database?

1275

Explain nested trigger in sql?

1126

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1938

How would you choose between a clustered and a non-clustered index?

1018

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1055

How to select all columns of all rows from a table with a select statement in ms sql server?

1185

Explain about link server in sql server?

1104

What are logical/boolean operations in ms sql server?

1100

Which are ddl commands?

1111

You want to implement the many-to-many relationship while designing tables. How would you do it?

1043

Will the writetext statement activate a trigger?

1149

What is the benefit of normalization?

1127

How and why use sql server?

1054

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1085