The mirroring configuration is with high protection with no witness. Is there a sql 2008 side-by-side upgrade documentation with sql 2005 out there? If yes, can somebody pls share it?

I will be doing a side-by-side upgrade on my sql 2005. any issues when my databases are on SQL 2005 are in principal mode?

any update on this will be greatly appreciated.

Gentleman,

Thanks a lot for the contribution. the provided info was very helpful and i was able to resolve my issue.

you guys are best.

Thanks again,

thanks for the help.

thanks for the detail answer. its clear to me, what to expect from sys.traces.

thanks again,

ok here's my findings:

On most of production SQL Servers (SQL 2005-64 bit) the value reads as follows:

Page life expentecy: 27,000

Buffer Cache: 100%

Page faults / Sec: 10.90k (Average)

The first two coutners...

David,

Thanks for the detailed answer and analysis. indeed it was very helpful.

with what i learned, it seems total server memory itself can not justify a memory pressure. but with what...

thanks everyone for the contribution. I see we covered quiet few areas concerning memory. but quiet frankly - i still have one simple question. is there a way to know...

Thanks for the contribution.

I read few articles listing total and target server memory. total server memory is the current memory in use by SQL Server. Target is what it intend...

Grant you are the best. Krishna thanks for your contribution as well.

The application i am runing is a vendor specific and i have to go back to the vendor to...

Thanks so much for the contribution. I will implement the proposed solution. in-case i see this happening again, will come back to bug you guys again.

Thanks again,

OK - here's what i got after enabling trace flag 1204 - 1222. I still do not understand where to read this deadlock information.

Apprecaited some assistance here:

Thanks,

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

04/06/2009 15:25:37,spid23s,Unknown,waiter event=e_waitPipeGetRow...

Thanks all for contribution.

I have enabled the 1222 trace flag and waiting to see deadlock error. will post if i see anything.

Thanks again,

thanks for the contribution. indeed it helped and gave me lot of insight into sql features.

we are implementing a new data warehouse environment and the initial idea was to...