Thanks and am Glad with your words of helping...

Will check the articles and will do reply .......

Thanks much for your reply...

Will check if that can be possible on our servers to take action of running trace profiler...

As this server reaches to 98% in CPU utilization...

Thanks for your quick response....

As i have no idea about trace flag , what you have said. As i have never used profiler or tracing as there were no such...

We have an audit table which stores the details of the errors on application. As you said the users are facing TimeOut errors and save profile errors, update errors....

There in...

What kind of server is it? how busy is our server, I mean what are the usual operations that are running?

What is your index strategy?

---------------------------------------------------------------------------------------------

We are on SQL server...

Thanks for your replies.

Sorry for the late response and improper tooo....

1. Actually i was talking about the LOG Shipping backup schedule. We have scheduled LSBACKUP for every 12hrs due to...

Backup schedule is at every 12hrs , so it will work at 12am hopefully.

For querying fast we are using the dbreindex every night as to reduce appilcation errors.

Thanks for reply,

But this operation is scheduled every night at 12am. How can i change that when no resource is available. And the reindexing is not allowed to run in...

Excellent....... Its working like anything.......

Thanks a LOT for you rfast help......

Chill & Cheers,

CH&HU...

Hi,

Am running the below query as it is -

-----------------------------------------------------------------------

exec msdb..sp_send_dbmail

@profile_name = 'Chandhra_local',@recipients='cshekhar@agilitylogistics.com'

, @subject ='Log Shipping Backup Job succeeded'

, @QUERY = ''select top 7 j.name as Jobname,jh.message, run_status, run_date,...

Hi,

After running your query i got the below error :

Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107

No global profile is configured. Specify a profile name in the @profile_name...

Thanks alot Dear for taking time to respond,

I tried this and working fine to result. Other than this i tried the queries which stored in MSDB they are working fine...

Can anyone please look into this ASAP.

And help me out in making this possible............. 🙁

Thanks for the reply,

It only shows the process succeed or failed. I have already done in the past and working on that. My wish that to mail a status report...

Mohith :

--------------------------------------------------------

SELECT TOP 50 qs.total_worker_time / execution_count as avg_worker_time,

(SELECT SUBSTRING(st.text,

...