Thanks for your reply. Sorry Buddy. I need the output to be stored in HTML format or the output should create an excel & store automatically in it.I dont need...

HI,

There is no parameter for this stored procedure,so parameter sniffing is not the issue i hope. When i execute only the stored procedure it gets executed.

Hi Mike,

Since i stop the job to avoid issue's in production there is no history maintained. The Job is not getting failed also as it keeps on...

Hi ,

Last week we increased RAM and processors. now ,In our environment we have 2 processors,6 cores and hyper threading present ,so a total of 24 processors (6*2*2) available with...

Can anyone reply with the appropriate answer !!

Is there a permanent solution to prevent time out expired.

re-index step alone kept running 7 hrs..

re-index was the lead blocker..

Normally what are the causes for this type of long running re-index query ?It ran for 7 hrs.. normally it would run within 5 mins. I checked sp_who2 active...

Thanks a Lot... Is repliation the best possible way.. Nothing else can be done ?

Hi Jayanth,

transactional replication is not a good fit for near to real time reporting since you have to pause the replication, then mount the database before it can be queried/reported...