Hi my mistake it is 2003 not 2005. What is is likely to be the main thing we need to look at based on the settings I have posted? My...

AndrewSQLDBA (8/12/2010)

---

You have not stated what the OS actually is. SQL Server 2005 is not an OS.

Is this a web app? or a GUI app? What language is the app...

AndrewSQLDBA (8/12/2010)

---

You can get rid of the old fashioned ODBC connections and use the more modern OLEDB connections. That could be part of the problem in transferring data back and...

Leo.Miller (8/11/2010)

---

Available Memory is misleading, SQL is memory hungry and will use all the memory it can.

Some questions:

How many CPUs?

How big are the relevant tables?

Is the application running on the...

AndrewSQLDBA (8/11/2010)

---

I just noticed this in your post. The CPU goes from 1 to 90 percent. What else is running on that box? Is this a spike? or a constant?...

AndrewSQLDBA (8/11/2010)

---

What does SQL Profiler tell you about the query? Use that and it will tell you what the query will do.

There is always room for improvement in a database....