Execution plans are not entirely the same. ...

Hi everyone,

I am reading how database mirroring works in SQL Server TechCenter and I am having a problem with this paragraph, specifically, the bold parts:

"To store the copied original...

We found out that some of our queries ran very slow on 2005 compared to 2000. A query that ran in 5 minutes in 2000 took 8 hours in...

That's great, thanks for the hint!

OK, found the Failover button in the Mirroring window. 😀 It seems to be the best way to accomplish what we want.

Is it possible to look...

You could get away with the Workgroup version. Express has a maximum database size of 4GB and it doesn't have job scheduling capabilities. I wouldn't recommend it.

Thank you Marios!

Thanks for your input all.

Thank you very much Gail for answering my questions. I don't have the same problem that the OP has, but I ran your query and was surprised by the...

My apologies, I misspoke. My log backup removes the committed transactions after it backs them up. Will that interfere with mirroring.

I have SQL 2005 SP2, with 16GB of RAM on the server.

Also, a couple of people here raised contradicting points about the cache used for sql plans. ...

Thanks SQLGuru.

I have a question about mirroring. Would my log backups that truncate the logs interfere or fail the mirroring?

GilaMonster (3/27/2008)

---

How much memory do you have? What service pack of SQL are you running? 32 bit or 64 bit?

If you run the following, what's taking the most memory?

select [Name],...

What are the things that are not logged? I know truncate is not logged. Are there any other commands?

Michael Valentine Jones (3/26/2008)

---

If you have a whole week to get if from LA to SF, back it up on tape in LA, ship the tape to SF overnight express,...