Thanks a lot J-F. I have suggested dev to perform those changes. will post the updates here.

Thanks,

Sudhie.

J-F

it hangs only when called from other stored proc, when executed itself it will work. so global variables shouldn't be an issue right.

Correct me if i am wrong..

Thanks,

Sudhie.

Thanks a lot for the input.

am not sure of application that calls..but most probably be .NET. Do we have any alternative in .NET..

any suggestions about alternatives ?

Thanks,

Sudhie.

Sorry its other way around Sp2 calls Sp1 and Sp1 has got this xp_cmdshell. Sp1 when executed on command line works. But when SP2 calls Sp1, it hangs

xp_cmdshell query is...

Ellie - i never tasted disaster but during deployments, i use to take the site backup. Once deployment went wrong and we have tried something on config database which forced...

I cannot give point to point answer with my expertise. But here are few i know

Create a scheduled task using task scheduler and take backup of your sites and...

More info on Disk fragmentation -

There are 4 drives

C: 40% fragmented

F: 49% fragmented

S: 45% fragmented

T: 39% fragmented..

Thank You..we have changed the model to SIMPLE to allow few hardware upgrades and we will be changing it soon.

I got this question because, Insert was taking long time...

Manually use this query and schedule it..

declare @dt datetime

select @dt=getdate() - N-- N is the files with Ndays old

EXECUTE master.dbo.xp_delete_file 0,N'Backup Location',N'BAK',@dt

Please let me know if you require any thing else..

i will go through avoiding deadlocks in BOL, thanks for that..

Gail - This is the deadlock graph

2009-02-26 17:46:20.70 spid4s Deadlock encountered .... Printing deadlock information

2009-02-26 17:46:20.70 spid4s Wait-for graph

2009-02-26...

PSSDIAG is taking many filters, but when i checked its XML, it is taking only 5 filters. I filtered for a while using text data and then started tracing without...

i was able to inject more filters into PSSDIAG and i entered all Object ID's, Duration and database ID as well...

will test it and let you know if it works...

Thanks Roy, that certainly helped. I just saw another option in PSSDIAG, it is allowing me to enter 5 trace filters on an event. I am planning to enter Object...

Is there a way to monitor more than one SPROC? In other words, can i monitor more objects..i have 9 SPROCS to be monitored..