simple timeouts on every operation involving that record

I was able to run the profile with small files using the settings you suggested.

So I decided to use a bigger workload to get some statistical variety. I used a...

Many thanks for helping.

Fact is my production server is not busy enough. The app is an internal one which is used only "sometimes". As I know what the most used...

Thanks for your answer and advices.

I am supposed to capture this event? Just let the profiler run and wait...

I was able to produce a trace from the SQL Profiler, but When i run the Index Tuning Wizard with that trace I get the error "the workload does not...

I know about that.

I didn't write the code so before doing anything else I am trying to index the DB (it's not indexed at all now). I am doing so...

Thanks a lot!

Giovanni

OK,

I set the track change property to Off and setup a schedule to run the indexing at night.

Thanks again!

G

Ok,

I discovered i have a full-text indexing active on one of my tables.

It seems while this 'job' is running if another job or process runs the DB is beign blocked.

There's actually...

it worked:

job_id: 929D9ADA-8CA7-420E-A37E-E96C7BEBB073 

step_name: Full-Text Indexing

command: use [HumanResources] exec sp_fulltext_table N'[dbo].[tbl_People_Attachments]', N'start_full' 

Can't find job ID on job's properties. How can I understand if this is one of my jobs of...

Perfect!

Many Thanks for your help guys,

G

Sorry,

I should have had specified.

No errors, when I look for a string I know is in there sometimes it doesn't find it.

Cheers,

G

Thanks,

now it works!

Cheers,

Giovanni

Version is 9.00.3042.

Probably is related to what you say.

I'll try to install the SP2 fix.

Thanks,

Giovanni Idili

OK,

many thanks once again for your help!

Giovanni