depend how many disque you have into your raid strip considere disque * 2 = normal disk queud lenght (5 disk * 2 = 10 ) the real calculation is...

is not good idea shrink tempDB depend activity on your database but 16gb is not unusual my production server have 40Gb for tmpdb into 6 physical files. maybe considere add...

maybe call microsoft support.

into your select statement you can put

select .... from table with (nolock) where

and into you update statement if you update only few row

update

set

from table with (rowlock)

where

or

prepapre your...

look this KB

http://support.microsoft.com/kb/934751/en-us

maybe check system performance disk queud lenght proc and memmory maybe considere monitor lock with third party software like

http://www.sqlsolutions.com/products/sql-deadlock-detector/index.html

cosidere review application to be sure lock is relase as...

select * not offert good performance into production enviroenment

maybe you need none cluster index on id and custom1 for the firrt querry

and

none cluster index on sid and clm2 for...

objet filter not work whith completbatch or sp complet you need filter whith texdata and like your table name but did you know querry run into this table and...

hi you can check execution plan if your querry make table scan or index scan if is your case need tune index if your querry update only one record...

tanks a make more presure on my supplier to fix this.

viva the revolution 😉

mmm yes MSDTC running into my SQL and IIS server too.

my problemes have not code source of this application and my supplier is not able to reproduce this error...

look this kb

http://support.microsoft.com/kb/937745/en-us

a tink is verry similar

look this

http://msdn.microsoft.com/en-us/library/ms175513(SQL.90).aspx

di you look into windows Sheduler or put in place trace to view who start trace whith this filter

exec sp_trace_setstatus

di you talkin about SQL profiler or perfmon tool