Hmmm.... Not sure. Are you getting any errors? What does the cluster look like in the Dashboard with the primary offline? You can look at the health event file? There...

ASITKAUSHIK (6/14/2012)

---

I would suggest pickup of any simple query and follow the below step

SET STATISTICS IO ON

<YOUR QUERY>

SET STATISTICS IO OFF

just see the if u are getting physical reads if...

And no, you shouldn't have to share storage in any way between the servers. That's the whole point of this new mechanism for AlwaysOn.

If you take a look at the dashboard, are all your replicas synchronized or synchronizing? I've run into issues when the automatic failover was not synchronized. I just ran a...

I usually just set the database to restricted_user (assuming I've got proper control of the server and everyone isn't logging in as 'sa') and use WITH ROLLBACK IMMEDIATE set. But...

That is a weird one. I think I'd open up a Connect item. Since the raw data is coming from Microsoft metrics using Microsoft tools, surely they need to provide...

Not sure. It's not something I've seen elsewhere. There aren't any huge, general, performance improvements between 2005 & 2008, but there are no huge performance degradations that I've seen either....

Koen Verbeeck (6/14/2012)

---

Kiara (6/14/2012)

---

So, I'm moving to a new laptop. And trying to decide whether to stick with my dev environment installed locally on the machine, or building a/several virtuals...

Kiara (6/14/2012)

---

So, I'm moving to a new laptop. And trying to decide whether to stick with my dev environment installed locally on the machine, or building a/several virtuals to put...

Don't pull the indexes. That would be bad.

I'm with the others, putting an index on the FKs is a good idea. In fact, you might want to try changing the...

Just to narrow it down for you a bit, memory management is primarily predicated on the OS, not SQL Server. So a 32-bit OS with a 64-bit SQL server, the...

No, that's almost the opposite of what I see in most cases. Usually PLE is a constantly increasing value which suddenly drops to near zero once a day or once...

It's not just the sorts though. You're scanning hundreds of millions of rows. The sorts are making things worse, yes, but the sorts are setting you up for merge joins,...

Timeouts might be from blocking during the rollback of transactions that were selected as a victim of deadlocks, but I'm with Gail, it's likely just standard blocking. Deadlocks are both...

Validate the settings are basically the same between both servers. Enable the 'Optimize for Ad Hoc Workloads' option on your server. That frequently helps ORM apps. Possibly look at using...