Jeffrey Williams-493691 (7/3/2011)

---

It is possible that it is taking a long time to recover because you have a large transaction log - with a lot of active VLF's.

How large is...

Hi,

Thanks for the quick response.

I executed your script and got the below single record...

----------------------------------

2011-05-08 20:44:33.940

Server

Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.

----------------------------------

Thanks.

Thank you all. I will do drilldown into it.

Thanks. I was not aware about it as well. Hardly worked in Integration Packages. Thanks again.

Thank you somuch.

Will update in production server and see.

Thanks to all again.

Thanks for your response..

I did it this way as I dint have entire solution.

I created new package in BIDS. Imported this particular DTSX file. Modified it. Build the package and...

Thanks...

1. In this case what will be the maximum memory used by SQL Server .?

Is it dedicated server. If its dedicated server leave 2 GB for OS. set the...

Thanks a lot

Expertrs, I am still waiting for an answer.

Is Browser service useless if I decide to allocate PORTs manualy to all my names instances .?

Thanks again.

Oh Goood... I am extremely sorry.

Infact I was asking if I allocate static PORT numbers... Not IP Addresses... It's a typo from my side. Sorry.

Wel, Wot if I allocation static...

... Excellant.... That makes us "Normalized"..!! 🙂

Thank you so much. Am clear now. Will go through the books you mentioned.

.......... I am bit worried that you are the only one responded to my post. ..................

No. It's same, blanks.

So I am...

No it's not connected to SAN..

Log files are in the same disk but in different drive.

Thanks.