These are the information I have with me now. Do let me what do think about the counters and how should I proceed further.

System info:

Hardware: Intel Xeon MP @ 3.00GHz...

Either create a new device and take the backup or overwrite the backup file for the same device which is by default.

example you have create a devices with xyz.bak as...

Hi,

Operating system error = 2(The system cannot find the file specified.).

Is a very straight forward error message

Please check if the file path is same , or check if...

Thanks for the reply.

Those two tools will help me in monitoring the load.

I need to generate the load in the Database to check if it is able to handle...

Thanks for replying. 🙂

Even I told them to tune the query if they want good response time. Plus the temp db space is about 3 GB and the increment is...

Ouch. that hurt!!

This is the query they are not ready to change. What best solution can I give them to tune it? As I see lots of Data file and...

Hi All,

Iam still working on the High CPU utilization..As per the suggestions We have created cluster indexex and some non cluster indexex which has increases the performamance of the...

Dear Gila,

Please find the query.

Thank you all for your support.

Thanks Grant for pointing out issues with the code.

Jeff Please find the Qery text for your ref. Iam waiting for your and Gila's comment...

Gordon , I really appreciate the way you have helped Nicole and also us.

I Solved the issue this was the access permission issue to the SMTP mail server.

Let me explain step by step how did I configure Database mail for SQL Server 2005...

I would like to go for import wizard too. It is simple too.

Thank you all very much. I had a sleepless night thinking how should I tune?

As you all are there to help me out Iam quite sure I will try using...

Is it possible to send us the DDL of the table and also the execution plan which will helps more to understand.

Have you created cluster index if not then try...

You can also use profiler for the same which is more accurate yet consume lots of space. If space is not an issue then go ahead with it.