greatly appreciate any suggestions on this issue ?

Both.

They are reporting slowness.

And I am Thinking the slowness is because of waits ?

I am not sure how to toubleshoot from here?

For better better performance what Should I must do...how...

Below shows the Wait Category:

Wait CategoryNumber of WaitsWait Time (sec)% Wait Time

Parallelism277458685332375283.6260.11%

Number of WaitsWait Time (sec) %Wait timeMax Wait Time (ms) Avg Wait Time (ms)

CXPACKET 277458685332375283.62 ...

Thanks

If there is any script belonging to it. please post it.

Thanks in advance.

Can explain it a bit clear.. I am not get how to do it.

step by step process please.

Unable to connect to SSMS. But, The server responds to a PING.

When I check the application log. I found an error.

Event Type:Error

Event Source:MSSQL$CCGEDMI1

Event Category:(2)

Event ID:17058

Date: 1/14/2011

Time: 10:35:08 AM

User: N/A

Computer:LSMTD4810

Description:

initerrlog: Could...

@ Pradeep: I am not aware of SP_PURGE_JOBHISTORY.

what it will do. Is there any alternate solution of fixing the bug.

How do I skip it from the daily maintenance job?

I don't see enable option on the index. should i drop and recreate the index.

Any faced this issue or have any idea please replay. As it is our PROD server. that would be very much appreciated!

Some job have like 4-5 history and some jobs don't have any history. So I want to set up at 4 weeks.

In all our PRD servers.

Once the Full Backup finishes, I call the Check DB Integrity job from the Full Backup job.

Then the Check DB Integrity job runs and when...

Then the tempdb.mdf file in original D:\ drive can be deleted?

Thank you Jack.