CirquedeSQLeil (6/22/2010)

---

GilaMonster (6/22/2010)

---

What a surprise. Not.

At least we didn't lose every match we...

Looks about right.

Good luck, let us know if any issues.

A.

Well the max mem size followed by sp_reconfigure is generally immidiate. As long a max size is not being set to lower. The lock pages in memory requires a sql...

Not sure really, it depends on whats been done. To be 100% sure, make all the suggested changes (max size and lock pages in memory), then restart the entire server...

Yes the code is a seperate query.

Set the max memory and then run sp_reconfigure.

Then verify lock pages in memory (if you have to set i t it will require...

Ok a few ideas from my colleague:

1. Set max memory to 5GB (you'll need to run sp_reconfigure or restart), this leaves 3GB for OS + Apps.

2. Lock pages in memory...

Colleage of mine just made a suggestion: Have you locked pages in memory? This done through gpedit.msc and has to be enabled for the sql service user.

dont worry, i have edited now. Read last.

EDITED: Sorry, I'm talking sh*t.

The top two databases are using the most memory but you said you had 8GB so this doesnt come near. What are your other memory stats?...

Paul White NZ (6/22/2010)

---

I guess it's because there's no-one...

This might be a stupid suggestion but is it the default profile? The other day i had a issue where the mail wouldnt send and it was because i had...

WHat she mean is that you cant restore/revert a database back to a past time without at least...

Henrico Bekker (6/22/2010)

---

I don't really think the poster would consider staying on SSC if he saw your post regarding his question, do you?

Even though this forum is maybe for blowing...

Henrico,

While i take your point, this forum thread is titled 'Are the questions getting worse?', its quite clearly meant as an area for people to blow off steam. I wasnt...

AWE does not do anything on a 64-bit system (enabled or not). Have you run any scriptps to show the memory usage per database?

SELECT CONVERT (varchar(30),

GETDATE(), 121) as runtime,...