that article is saying on a 32bit system AWE will allow you to address memory above 4GB for the buffer pool. Otherwise you are limited to either 2GB, or 3GB...

PHXHoward (3/13/2012)

---

Thanks for all the great information.

The Microsoft rep that we have on site this week confirmed that enabling AWE and LPIM on the 4gb RAM 32bit system would allow...

Is this an outsource? If so KT should be your area of expertise.

....or have I read this wrong and the configuration file just needs changing to QNXTDB02STL\QNXTSQLSTLTST01

Firstly the app is at fault. It appears not to be able to cope with a named instance.

I wonder if setting up a server alias of QNXTSQLSTLTST01 for the named...

presuming you got the error above and the account you are using has admin privileges, grant the account full control over the mssql directory which your data directory that contains...

your database is probably in full recovery mode but you are not backing up your transaction log.

Switch to simple recovery mode

run a checkpoint in the database

then attempt to shrink the...

Have you ticked the box to show updates as well?

what results do you get when you run select @@version?

Did you get an error when applying SP3?

opc.three (3/10/2012)

---

Note: my comments pertain to 32-SQL Server Standard Edition running on 32-bit Server 2003 R2 with 4GB physical RAM and the /3GB switch enabled.

george sibbald (3/7/2012)

---

As you only...

Its the other way round, you need LPIM enabled if you want to use AWE.

and the trace flag is to use LPIM with standard edition 64bit. See the blog I...

grant them view server state, also sqlagentreaderrole should be enough.

Logs are generally separated from data files for performance reasons, there is no performance benefit in separating system db data and log as they are not updated enough. My advice...

Gianluca Sartori (3/8/2012)

---

george sibbald (3/7/2012)

---

I would ask why? Master and model are hardly updated, msdb not much more so why bother splitting out the log?

You can a make a case...

I would ask why? Master and model are hardly updated, msdb not much more so why bother splitting out the log?

You can a make a case for tempdb and thats...

jake.mayher (3/7/2012)

---

Your first option looks great.

If you have the ability, I would also recommend:

1) Use RAID 10 on the log file drive

2) Use RAID 5 or 6 on the data...