Thank you very much, so master,msdb,model I will check for:

Check integrity,reorginize index,rebuild index right?

Where is that option located thank you agai

Thank you, for the trace when I start running, what options should I check for?

'Kôjee p'Ofoire'

How can I write corectly in insert values('Kôjee p'Ofoire' and you can't do that [Kôjee p'Ofoire]

we have 3 ' of them and that wouldn't work

Hello, my temp is getting bigger,I have now 381 mb. I just installed sql monitore,but this tool is not providing why temp db is getting better.

Any ideas what I should...

Here is my results:

I am ran this script on SQL Server,

SELECT command,

            s.text,

            start_time,

            percent_complete,

            CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour(s), '

                  + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + 'min, '

                  +...

I re started server and my temp db got very 111.38 MB small, but I would like to monitor and see why it got so big before.

I am restoring as a new database

Hi,

I rebooted my server and tempdb got much smaller, just

added sp_configure 'show advanced options', 1; GO RECONFIGURE;GO

sp_configure 'default trace enabled', 1;GO RECONFIGURE;GO code and ran code for:

;WITH task_space_usage AS (

...

My default trace is enabled,so can't check

also told you to check the default trace to see if maybe a job was doing that.

Sorry, how to check that?

Checked usages for tempdb and attached scripted

Cleared cache,shrink temp db

I just ran it for temp here is my results.

Thank you

I will try it now, Thank you

DBCC FREESYSTEMCACHE('All').

How long this will run, do you think?

Thank you