Monday, November 9, 2009

SQL Server x64 memory performance

I have a client who sells medical software and some of their clients are complaining about performance on SQL Server x64. A little research showed that the permissions for the account running the server were incorrect.

Looking at Microsoft's support site there are two links you should check out.
The first:
Describes the problem in detail and permission and setting changes to help.

The second is a link the to hotfix that is available.

Don't forget about enabling trace flag 845.


1 comment:

  1. Also look at database file initialization at: