Sqlenthu,

A simple answer for you is to check the SQL instance out right away.

Brent Ozar has a great, free tool for this: spBlitz which can be downloaded here: [/url]

You just have to run the spBlitz code to create the stored procedure and the run it in SQL. It will tell you most everything that is wrong in the environment.

Then you can start getting more in depth with fine tuning the performance.

Hope this helps!

Jon