Thanks for all the inputs...

I Have reconfigured the LS again... Its working fine now...

there are 5 - 6 long running queries to get the data from couple of servers. Trying to tune them fine.

and i have already set the query timeout to

...

Yes,

The only thing i can do is backup and restore. But apart from that can't i restore or perform any backups on this db ?

Thanks for the fast reply Hans.

Can that be in a specific or described.

Dear All,

According to J-F am done with the changes like improved CPU RAM for 5Gb as it was only 2GB earlier.

Need to change the equery timeout and the application connection...

It won't effect your backup plan, but make sure that LSBackup job which should not conflict with the other backup plans at a time.

As they said is correct.

Full backup will...

Are both SQL server and SSAS running on the same machine?

We run both on the same machine, but memory took awhile to balance out.

We had to set limits on both...

Hi All,

I have already set the timeout executions, Indexing, Scans and i found there are number of queries running for Highest CPU utilization....

Still am facing the same errors with...

Thanks Hans,

But still am not able to fix these issues or errors.

Its OLAP machine. Where we configured for Log Shipping process for 8 databases.

Can anyone provide me the...

Thanks for the reply,

Actually we are facing the issues like : TECH_MESSAGES like,

1. Object reference not set to an instance of an object.

2. ...

Thanks Rajini... for the reply..

Yes i agree with your things.. I want to kill the processes for long time hanging.

Main intention is to kill the process which simply kept idle...

select waittime,spid from sysprocesses where waittime >= 120000 --(2 mins in milli seconds)

and status like 'sleeping'

If i run the above query i can see no results. As i...

Dear Rajini,

Thanks fro your inputs, but am facing the below error with the script provided by you...

Msg 2716, Level 16, State 1, Line 19

Column, parameter, or variable #1: Cannot specify...

Great Rajini....

I tried with Local machine and DEV env now trying to TEST that in UAT...

i Can set that time to 5 mins right ???

Thats what am testing now....

I will...

Dear All,

Me tooo having the same issue....

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2009-05-08T14:12:29). Exception Message: Cannot...