Answer Posted / ponguru

It is very big thing...Let me explain in short..Run the
profiler and catch the Logical reads/Physical reads/CUP
values.

find out where values are more(huge) and take Excution plan
and study it ...here you can find out where the problem.

In general scenarios Data also matters that means If your
Dev/Test enviroment not having that much Data which has
Prod.

Get the large Data and do above scenarios and you came know
what is cause.

How to delete an existing database user?

1022

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1008

---

What is resource db in sql server?

1032

---

What are scalar functions in sql?

1151

---

what are the types of indexes? : Sql server database administration

1129

---

What are logical/boolean operations in ms sql server?

1051

---

How do I create an extended event in sql server?

958

---

Explain what is “asynchronous” communication in sql server service broker?

923

---

Is sql server difficult to learn?

925

---

What is sql server 2000 work load governor?

1073

---

How to set database to be read_only in ms sql server?

1016

---

How to drop an existing table?

1013

---

How to achieve Paging of records in SQL SERVER?

1104

---

List out the different types of locks available in sql server?

981

---

What is enhanced database mirroring in sql server 2008?

976

---