I'd agree with @troubleshootingsql. Set max memory in each instance, with the sum of your settings being 2GB less than the total memory.

Or to make it easy, set each instance...

Added spaces into the code. Should look fine now.

John Mitchell-245523 (5/9/2011)

---

I discounted Page splits/sec because page splits are also caused by INSERT statements, and therefore if you wanted to measure the rate at which UPDATE statements cause data...

Christian Buettner-167247 (5/9/2011)

---

The answer does not sound right to me.

For heaps, there are no page splits, therefore the only counter that gives me the answer for both, indexes & heaps,...

Speed definitely matters. If your software doesn't take a longer access time into account, it can be an issue.

SQL Server doesn't provide you any way to read the backup file and extract only a table. There are third party tools that can do this, but you would have...

I don't believe that configuration changes are in the schema changes report.You want the Configurations Changes History report.

Enjoy!

SanDroid (5/6/2011)

---

Paul Randal (5/6/2011)

---

There's no choice but to have it behave that way because something in the transaction log that gets recovered at the end of the restore good disable...

I'm not sure there's something you "need" to know about R2. There are more features, PBM is enhanced, filestream, etc. that are changed a bit, but I'm not sure there...

What best practices are you looking for? SQL Server is so wide, with so many features, it's hard...

AFAIK, most people are still running with SPs. I haven't seen much positive or negative on the R2 CUs.

I'll check the R2 link

pubic is a role that should not have permissions assigned. That query returns nothing for my instances, which leads me to believe someone has assigned permissions on your server.

If I...

Tom.Thomson (5/6/2011)

---

You're right :blush:. Sorry, brain wasn't functioning - I looked at it and thought "how many heaps" and answered that instead of what was actually asked; and then didn't...

Interesting blog post from Roy. Anyone ever tried this?

http://www.sqlservercentral.com/blogs/dba_rumblings/archive/2011/05/06/why-you-should-ask-your-cto-to-attend-the-user-group-meetings.aspx

I used to go to a networking conference with my boss. A bit of a boondoggle, but I did get to point...