Sorry for the late reply. Was away for week days.

Thanks for your post and suggestions.

I will test the same and post you reply.

<< Add on >>

We have some jobs (SSIS packages, gets data from 3 different sources) run for 20 hrs max.

Sometimes, due to load or some other factors, the job hangs...

Thanks for the reply.

I just wanted to know, what actually was wrong in HTML format.

I modified it to different format but I get results in text in one liner.

Hence, I...

Thanks for your response.

I will still wait for some real stuff that helps on my query that was used..

Appreciate any help on this

one more query to send report in HTML

DECLARE @xml NVARCHAR(max)

DECLARE @body NVARCHAR(max)

-- specify long running query duration threshold

DECLARE @longrunningthreshold int

SET @longrunningthreshold=1

-- step 1: collect long running query details.

;WITH...

Here is what that I am using from one of the sources. So that, everyone gets benefited.

I modified many points all over, but still I am unable to get the...

Greetings All,

Thank You very much for your replies.

I am still in testing state and I am following the links that are pasted.

I will be back with the results and tests...

can anyone help, what if the DB is switched from FULL to SIMPLE and SIMPLE to FULL. what happens in back end ?

How this bitmap fixes and how it got...

Yeah, I know their recovery models are irrelevant to mention here.

I cannot move files right now, I need authorization again for this.

Why am I not able to backup still, what...

we have 10 DBs on the instance and all rests on the same drive...

they are all of 80 MB of sizes..

All the DBs are in SIMPLE recovery mode.

What files are on this drive? The database's data file, log file? What else?

-- LOG files only

I see this behavior as strange..

I assume the ETL process or Bulk operations would have blown this LOG file to max extent even it is in SIMPLE recovery mode.

Thanks much Gail for helping me on this issue.

-- Sorry for the late response.

-- Shrink dialog shows the same 0 M free space available.

-- Log_reuse nothing has changed

Reorganise pages is...

we have the same 4 MB free space available on drive.

what if I work on Shrinking the LOG file using second option ?

-- Reorganize pages before releasing unused space -...