If your SQL Server and users are in the same security zone (ie, internal production network) then there is no argument for or benefit to using local machine service accounts....

As MarkusB noted, to take advantage of the RAM above 4GB you will need to upgrade your Windows installation to Enterprise. This is a re-install job.

MOM and HP SIM are quite intensive databases to operate, especially MOM. I would recommend a high level of disk separation for your MOM database files for IO performance.

Some other general points to look at are

- Least privilege for your service accounts. They don't need to be local admins. A standard user account with the...

Sounds like your shortcut was in either C:\Documents and Settings\All Users\[Desktop|Start Menu]\ or C:\Users\All Users\[Desktop|Start Menu]\

A nasty solution is recorded here http://robbo.com/2008/11/26/sql-on-windows-server-2008-remember-to-run-ssms-with-elevated-privileges/

Basically, run SSMS in administrator mode.

TheSQLGuru (1/27/2009)

---

>>As was mentioned earlier, SQL Server will allocate as much RAM as it can. This can often cause problems because SQL neither knows nor cares about other processes...

As was mentioned earlier, SQL Server will allocate as much RAM as it can. This can often cause problems because SQL neither knows nor cares about other processes on...

There are two solutions to your problem. One incurs an outage, the other doesn't

Traditional solution incuring an outage

Restart SQL Server in single user mode - http://msdn.microsoft.com/en-us/library/ms188236(SQL.90).aspx

More information

You should never assign privileges / rights / permissions to an individual account. You assign privileges / rights / permissions to roles which groups / teams and individuals fulfil.

The...

As always, mileage will vary depending on your hardware.

Some rules of thumb

- have your logs and data on different sets of spindles

- if you can't, then at least...

AWE is not required, not available, on a 64bit system. It was included as a workaround to solve the maximum 2GB address space available to 32bit processes.

To limit your...

I suppose it would have helped had I seen that there are 4 pages of this thread, and read them, prior to posting. my bad.

One thing that hasn't been...

Not going into any SQL specifics in terms of how it will write data to your data files, filegroups, etc...

RAID 1 will give you 1x write performance and 2x+ read...

Are you using local disk, SAN or NAS? what sort of disk configuration (RAID level, how many disks) are you using? How are you connecting to your disk?

...